padsurfer
New member
I'm in the progress of trying to learn the basics of ADO.net with a simple test app, which im playing with using VB express addition. I'm having a problem which im hoping someone can help me out with.
In the following code:
cmd.CommandText = "INSERT INTO People (Firstname,Lastname) VALUES _('Hope', 'Goodie')"
iRowsaffected = cmd.ExecuteNonQuery()
MessageBox.Show(iRowsaffected)
i also get a text box saying 1, which means that the row has been added.
Straight after this (in runtime) i then populate a listbox with these table records and my new addition is listed. I think great all good so far, however
when i end the runtime, and check the database it has no record of the last
addition i created during runtime. Can anyone tell me why, and how i can change this so it does.
Thankyou.
In the following code:
cmd.CommandText = "INSERT INTO People (Firstname,Lastname) VALUES _('Hope', 'Goodie')"
iRowsaffected = cmd.ExecuteNonQuery()
MessageBox.Show(iRowsaffected)
i also get a text box saying 1, which means that the row has been added.
Straight after this (in runtime) i then populate a listbox with these table records and my new addition is listed. I think great all good so far, however
when i end the runtime, and check the database it has no record of the last
addition i created during runtime. Can anyone tell me why, and how i can change this so it does.
Thankyou.