Can you run a SQL script on a DataSet?

[Cricket]

I'm curious if you can execute a SQL script against a disconnected DataSet?

For example;

UPDATE tblFeature SET [Name]='New' WHERE uid=4

This would then update the DataSet so that when I execute the Update method on a DataAdapter it would update the database appropriately.

Currently I have to go find the row manually and then update the value.

 

[ritesh_jain1982]

Hi Cricket.........

There is no such Direct MEthod to Modify records in ur Dataset..........

U can do same this using (Provided u r Datatable have Primary Key............)

pi_dtTemplate.Rows.Find(1).Item("Name") = "Cricket"

I think this will help u ..................

Regards,
Ritesh