Update a Datatable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I update a row in a datatable?
My datatable has 1000 rows so a scan may take too long.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C# Query : Failed to populate DataTable 8
Determine the closest numbers to a specified number 2
Copy DataTable Rows Fast? 2
Datatable 1
DataView question 1
DataTable - set a specific row. 3
How to use images with a winforms datagrid 1
C# SqlDataAdapter question: tracking changes? 1

Back
Top