The Syncfusion® native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
I use dataset.merge to merge input changes to
a GDBG datasource. GDBG will display duplicate
records for modified rows. How can we update changes in GDBG to underlying database without retrieving?
Private da As SqlDataAdapter
Private ds As New DataSet()
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
...
ds.Clear()
da.Fill(ds, "dtCustomers")
Me.GridDataBoundGrid1.DataSource = ds.Tables("dtCustomers")
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
''merging changes to GDBG''s datasource.
ds.Merge(ds.GetChanges)
End Sub
ADAdministrator Syncfusion Team February 24, 2005 07:45 AM UTC
Hi Frank
I think you haven''t defined a primary key on your DataTable in the DataSet. The grid only relects what''s inside the DataTable.
The line ds.Merge(ds.GetChanges) is a unneccessary roundtrip. You merge your own rows back to the same place where they come from. If you do a GetChanges and updating against the database, then you''ll have to do a merge of this data.
DataSet modifiedData = ds.GetChanges()
da.Update( modifiedData )
Me.GridDataBoundGrid1.BeginUpdate()
ds.Merge( modifiedData )
Me.GridDataBoundGrid1.EndUpdate()
Me.GridDataBoundGrid1.Refresh()
Regards,
Thomas
>I use dataset.merge to merge input changes to
>a GDBG datasource. GDBG will display duplicate
>records for modified rows. How can we update changes in GDBG to underlying database without retrieving?
>
> Private da As SqlDataAdapter
> Private ds As New DataSet()
>
> Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
> ...
> ds.Clear()
> da.Fill(ds, "dtCustomers")
>
> Me.GridDataBoundGrid1.DataSource = ds.Tables("dtCustomers")
> End Sub
>
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
>''merging changes to GDBG''s datasource.
> ds.Merge(ds.GetChanges)
>
> End Sub