Getting Data to Save to Database

Originally Posted by nch1978

I am new to programming and am sorry if this post is in the wrong area. I have a listbox bound to a table and a datagrid bound to another one with a connection through xml. I can change the data within the grid, with the following through a button on a different tab page within the form, but it does not save changes to the database, just shows them on the datagrid until the program is closed:

'Temporary Datasets to store the inserted or modified rows
Dim pdsInsertedRows, pdsModifiedRows As DataSet

'Set the menu items to indicate that a record is being edited
Call EditState(cblnNotEditing)

'End editing on current record
Me.BindingContext(DsClientServiceBinding1). _
EndCurrentEdit()

'copy the DataSet by getting the added or modified records from the
'origional bound Dataset
pdsInsertedRows = DsClientServiceBinding1.GetChanges(DataRowState.Ad ded)
pdsModifiedRows = DsClientServiceBinding1.GetChanges(DataRowState.Mo dified)

'Check to see if there is modified rows. If there is update the Dataset
If Not pdsModifiedRows Is Nothing Then
odbdaTickets1.Update(pdsModifiedRows)
End If

'Check to see if there are inserted rows and update
If Not pdsInsertedRows Is Nothing Then
odbdaTickets1.Update(pdsInsertedRows)
End If

'Synchronize the database with the Dataset by accepting changes
DsClientServiceBinding1.AcceptChanges()

Thank you in advance for your help,

Originally Posted by Dököll

Greetings and salutations!

I think this is what you want, looked through it myself. You'll need to do some reading:

http://www.codeproject.com/cs/databa...select=1644938

In a bit, and have fun with the project...

Originally Posted by nch1978

I am not sure I understand it. I have the connection, it reads the two tables, it lets me update and shows the changes in the tables on the form, but not in the database itself. Do I need to close and reopen the connection to update the actual database? Or am I missing something?

Originally Posted by Dököll

Excuse the confusion. You are adding back to the database (updated data is being added to the database). Do you have a "Save" or Add to Databse" button? or something in that kind of a line! Do the data you have updated through xml have texboxes specific to them on your form? Your button to Add or Save should send to your database.

Perhpas this one is easier to understand, look up the insert command:

http://blogs.msdn.com/codemouse/default.aspx

Write again if not helpful...