ADO.Net Update

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

Guest

Hi all,
I need to execute sql statements against a "DataTable" not the database.
For example i need to update certain rows.
One possible way was to use select rows and then loop through and update.

is there a better way,

Help appreciated

Thanks

AR
 
Abdul,

A datatable is not a database. Therefore you cannot use a select quiry
string.

Although that the datatable has the posibility to use the
Datatable.Select
Dataview.rowfilter
Datarowcollection.find
Dataview.find

Have a look at MSDN for this methods.

I hope this helps?

Cor
 

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

For Next Question 1
Project with dataset, datatable, and datarow. 2
updating database using datatable 1
Running Insert/update SQL against ADO.NET dataset 7
About autoincrement 1
DataRow RowError - Detecting at Table Level. 1
Adding Reference to Excel - which one? 3
Batch Update ADO.Net 2

Back
Top