G
Guest
How can I update a row in a datatable?
My datatable has 1000 rows so a scan may take too long.
My datatable has 1000 rows so a scan may take too long.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Joyjit Mukherjee
Hi,
Use the Datatable.Getchanges method to get the changed rows into a second
table, and use the Dataadapter to update the second table.
HTH
Regards
Joyjit
Use the Datatable.Getchanges method to get the changed rows into a second
table, and use the Dataadapter to update the second table.
HTH
Regards
Joyjit
G
Guest
Joyjit,
Can you give me more details, please.
dim ds as dataset
dim table as dataTable = ds.Tables(0)
dt = New DataColumn
dt.Caption = header
dt.ColumnName = header
dt.DataType = System.Type.GetType("String.Type") ' THrows an exception
table.Columns.Add(dt)
table.Rows(ix).ItemArray(columncount - 1) ='R' ' Does nothing
ds.Tables(1) = table.GetChanges ' doesn't compile
Can you give me more details, please.
dim ds as dataset
dim table as dataTable = ds.Tables(0)
dt = New DataColumn
dt.Caption = header
dt.ColumnName = header
dt.DataType = System.Type.GetType("String.Type") ' THrows an exception
table.Columns.Add(dt)
table.Rows(ix).ItemArray(columncount - 1) ='R' ' Does nothing
ds.Tables(1) = table.GetChanges ' doesn't compile