|
-
Jul 20th, 2004, 01:23 PM
#1
Thread Starter
Addicted Member
How to Save table to database
Hi all Gurus,
I am new to .net & I have very simple problem.
to save changes from dataset to database, I have written following code:
Private Sub updateDataSource()
'stop any current edits.
Me.BindingContext(DsInventory1, "Vendor").EndCurrentEdit()
Try
Me.ConnINVENTORY.Open()
' Attempt to update data Source.
DsInventory1.Tables("Vendor").AcceptChanges()
' DataAdINVENTORY.Update(dsChanges)
DataAdINVENTORY.Update(DsInventory1, "Vendor")
MsgBox("Record saved Successfully")
Catch updateExcepatoin As System.Exception
MsgBox("Can not save to data Source")
Finally
Me.ConnINVENTORY.Close()
End Try
It seems that code runs fine but no changes are made in database,
can you please help me out earlier.
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|