this is the function that my friend made for me..it connects to the single table in database,in this case to table "clanovi" ..i really need some help with this.. thanks in advance
Public con As New OleDb.OleDbConnection Public dbProvider As String Public dbSource As String Public ds As New DataSet Public da As OleDb.OleDbDataAdapter Public sql As String Public imeBB As String = "bazy-tenis" Public Sub Connection(ByVal tablica As String) ds.Clear() ds.Tables.Clear() da = New OleDb.OleDbDataAdapter con = New OleDb.OleDbConnection dbProvider = "Provider=Microsoft.ACE.OLEDB.12.0;" dbSource = "Data Source=bazy-tenis.accdb;Persist Security Info=False;" con.ConnectionString = dbProvider & dbSource con.Open() sql = "SELECT * FROM " & tablica da = New OleDb.OleDbDataAdapter(sql, con) da.Fill(ds, imeBB) con.Close() akcijaUpdate(imeBB) End Sub