Using visual studio with a local database i have created a small application to handle clients and meetings.
After creating the the database, tables and the dataset with relationship i have begin to use the datasource to add details to the form. I have setup update and delete queries.
When i run the form and input data it seem to work fine. I can click the save button, close the form, reopen it and the data seems to be saved. I can even close the entire VS then reopen, and run the form and the data is in the form that i have input.
BUT...
when i view the data within the table in the server explorer no data seems to be written into the database. Is the data being stored into the dataset memory? and not being written to the DB?
if so what do i need to do the get the data from the form into the DB?
Thanks
Cass
After creating the the database, tables and the dataset with relationship i have begin to use the datasource to add details to the form. I have setup update and delete queries.
When i run the form and input data it seem to work fine. I can click the save button, close the form, reopen it and the data seems to be saved. I can even close the entire VS then reopen, and run the form and the data is in the form that i have input.
BUT...
when i view the data within the table in the server explorer no data seems to be written into the database. Is the data being stored into the dataset memory? and not being written to the DB?
if so what do i need to do the get the data from the form into the DB?
Thanks
Cass
Comment