UPDATE SQL CE Server via DataAdapter - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


UPDATE SQL CE Server via DataAdapter

WaterboyVBWaterboyVB Posts: 1Member
Hi All,

I have an issue which I have been trying to resolve for a couple of days. I am trying to update the SQL CE Server (which is in my project) with the changes that have been made to my dataset.


Dim myConn As SqlCeConnection = New SqlCeConnection(My.Settings.db_Database_Application_ConnectionString)

Dim myDataAdaptor As New SqlCeDataAdapter

Dim mySQLCommandUpdate As SqlCeCommand = New SqlCeCommand("UPDATE tblTutors SET Password = 'pass'", myConn)

Dim mySQLCommand As SqlCeCommand = New SqlCeCommand("SELECT * FROM tblTutors", myConn)

Dim myDataset As DataSet = New DataSet



myDataAdaptor.SelectCommand = mySQLCommand
myDataAdaptor.UpdateCommand = myConn.CreateCommand
myDataAdaptor.UpdateCommand.CommandText = ("UPDATE tblTutors SET Password = 'password'")


myDataAdaptor.Fill(myDataset, "tblTutors")

DataGridView1.DataSource = myDataset
DataGridView1.DataMember = "tbltutors"

myDataAdaptor.Update(myDataset, "tbltutors")


The changes seem fine when displaying the data in the DataGridView however the changes have not been made to the SQL CE Server itself.

Can anyone spot where I am going wrong here?

Any help is much appreciated.
Sign In or Register to comment.