Im not really sure what exactly im using here first time ever trying to use a DB to store data but her is some background info from my program and some sample code...
I have a dataset called jukeboxdataset a customersbindingsource and a customerstableadapter.
a datagridview and 3 buttons load/erase/save , i have all those working can load the db and make changes in the datagridview and save that data.
DB is set up like this
coloums are: ID, IDCard, Credits, TPlayed.
id is set to auto increment
What i dont understand and cant find info on how to do is this
I have txtID.text that contains the IDCard # and txtCredit.text that holds a credit amount thats gonna get added. i need to be able take those values and insert them into the db directly via code or into the datagridview.. i cannot seem to figure out how to access a perticular row or colume in this grid.
more info on the type of db im using file extention is .mdb
Connection String
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\jukebox.mdb
Any help would be greatly appriciated and i do appoligise for my spelling firefox's spell checker has spoiled me and this new google chrome browser im testing dosent seem to have a spell checker or at least i havent found it yet!
I have a dataset called jukeboxdataset a customersbindingsource and a customerstableadapter.
a datagridview and 3 buttons load/erase/save , i have all those working can load the db and make changes in the datagridview and save that data.
VB.NET:
This loads my db in my grid
Me.CustomersTableAdapter.Fill(Me.JukeboxDataSet.Customers)
Clears my datagrid
Me.JukeboxDataSet.Clear()
Saves my changes to the db
Me.CustomersTableAdapter.Update(Me.JukeboxDataSet.Customers)coloums are: ID, IDCard, Credits, TPlayed.
id is set to auto increment
What i dont understand and cant find info on how to do is this
I have txtID.text that contains the IDCard # and txtCredit.text that holds a credit amount thats gonna get added. i need to be able take those values and insert them into the db directly via code or into the datagridview.. i cannot seem to figure out how to access a perticular row or colume in this grid.
more info on the type of db im using file extention is .mdb
Connection String
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\jukebox.mdb
Any help would be greatly appriciated and i do appoligise for my spelling firefox's spell checker has spoiled me and this new google chrome browser im testing dosent seem to have a spell checker or at least i havent found it yet!
Last edited:
