Can you run a SQL script on a DataSet?

Cricket

Active member
Joined
Jan 6, 2005
Messages
28
Location
Hamilton, ON, Canada
Programming Experience
5-10
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

Well-known member
Joined
Jan 10, 2005
Messages
53
Programming Experience
1-3
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
 
Top Bottom