Help with datagrid updating example...

[Paul M]

hi there,

this is the source code i use to populate a dataset, bind it and perform the
update on any changes made to the datagrid.

Only problem is when i try the update, it does not save back to the
database....
any help is appreciated....thanks,
Paul.

Private ds As DataSet
sSQL = "SELECT * FROM [tblUser]"
..............
..............'BIND THE DATAGRID WITH TABLE DATA...works fine.
With dgTable
.CaptionText = SourceName
ds = CreateDataSet(sSQL, tableName)
.DataSource = ds.Tables(0)
End With
...............
...............

Function CreateDataSet(ByVal sql As String, ByVal tablename As String) As
DataSet
Dim da As OleDbDataAdapter
Try
cmd = New OleDbCommand
cmd.CommandText = sql
cmd.Connection = conn
da = New OleDbDataAdapter(cmd)
ds = New DataSet(tablename)
da.Fill(ds)
CreateDataSet = ds
Catch ex As Exception
CreateDataSet = Nothing
Finally
da.Dispose()
da = Nothing
End Try
End Function

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Try
ds.GetChanges()
ds.AcceptChanges()
Catch ex As Exception
MessageBox.Show(ex.Message, "Save Changes", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation)
End Try
End Sub

 

[Uri Dor]

DataAdapter has an Update method. I suggest you look it up

 

[Paul M]

actually, yes in my latest code, after the AcceptChanges method, i have the
following:

da.Update(ds)

but it still doesnt save to the database???

Paul.

DataAdapter has an Update method. I suggest you look it up

hi there,

this is the source code i use to populate a dataset, bind it and perform the
update on any changes made to the datagrid.

Only problem is when i try the update, it does not save back to the
database....
any help is appreciated....thanks,
Paul.

Private ds As DataSet
sSQL = "SELECT * FROM [tblUser]"
.............
.............'BIND THE DATAGRID WITH TABLE DATA...works fine.
With dgTable
.CaptionText = SourceName
ds = CreateDataSet(sSQL, tableName)
.DataSource = ds.Tables(0)
End With
..............
..............

Function CreateDataSet(ByVal sql As String, ByVal tablename As String) As
DataSet
Dim da As OleDbDataAdapter
Try
cmd = New OleDbCommand
cmd.CommandText = sql
cmd.Connection = conn
da = New OleDbDataAdapter(cmd)
ds = New DataSet(tablename)
da.Fill(ds)
CreateDataSet = ds
Catch ex As Exception
CreateDataSet = Nothing
Finally
da.Dispose()
da = Nothing
End Try
End Function

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Try
ds.GetChanges()
ds.AcceptChanges()
Catch ex As Exception
MessageBox.Show(ex.Message, "Save Changes", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation)
End Try
End Sub

 

[vijai thoppae]

I guess you need to specify the table name while calling update.
da.update(ds,"table name");

~Vijai

actually, yes in my latest code, after the AcceptChanges method, i have the
following:

da.Update(ds)

but it still doesnt save to the database???

Paul.

DataAdapter has an Update method. I suggest you look it up

perform

the

update on any changes made to the datagrid.

Only problem is when i try the update, it does not save back to the
database....
any help is appreciated....thanks,
Paul.

Private ds As DataSet
sSQL = "SELECT * FROM [tblUser]"
.............
.............'BIND THE DATAGRID WITH TABLE DATA...works fine.
With dgTable
.CaptionText = SourceName
ds = CreateDataSet(sSQL, tableName)
.DataSource = ds.Tables(0)
End With
..............
..............

Function CreateDataSet(ByVal sql As String, ByVal tablename As String) As
DataSet
Dim da As OleDbDataAdapter
Try
cmd = New OleDbCommand
cmd.CommandText = sql
cmd.Connection = conn
da = New OleDbDataAdapter(cmd)
ds = New DataSet(tablename)
da.Fill(ds)
CreateDataSet = ds
Catch ex As Exception
CreateDataSet = Nothing
Finally
da.Dispose()
da = Nothing
End Try
End Function

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Try
ds.GetChanges()
ds.AcceptChanges()
Catch ex As Exception
MessageBox.Show(ex.Message, "Save Changes", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation)
End Try
End Sub

 

[Paul Delcogliano]

Call the Update method before the call to AcceptChanges.

Paul

actually, yes in my latest code, after the AcceptChanges method, i have the
following:

da.Update(ds)

but it still doesnt save to the database???

Paul.

DataAdapter has an Update method. I suggest you look it up

perform

the

update on any changes made to the datagrid.

Only problem is when i try the update, it does not save back to the
database....
any help is appreciated....thanks,
Paul.

Private ds As DataSet
sSQL = "SELECT * FROM [tblUser]"
.............
.............'BIND THE DATAGRID WITH TABLE DATA...works fine.
With dgTable
.CaptionText = SourceName
ds = CreateDataSet(sSQL, tableName)
.DataSource = ds.Tables(0)
End With
..............
..............

Function CreateDataSet(ByVal sql As String, ByVal tablename As String) As
DataSet
Dim da As OleDbDataAdapter
Try
cmd = New OleDbCommand
cmd.CommandText = sql
cmd.Connection = conn
da = New OleDbDataAdapter(cmd)
ds = New DataSet(tablename)
da.Fill(ds)
CreateDataSet = ds
Catch ex As Exception
CreateDataSet = Nothing
Finally
da.Dispose()
da = Nothing
End Try
End Function

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Try
ds.GetChanges()
ds.AcceptChanges()
Catch ex As Exception
MessageBox.Show(ex.Message, "Save Changes", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation)
End Try
End Sub