Update data without SQL statement

  • Thread starter Thread starter rkmoray
  • Start date Start date
R

rkmoray

I want to update a table without using a sql statement.
I am hoping for something similar to ado update.

ds.Tables[0].Rows[x] ["authorid"] = "Rick"
ds.update

is something like this possible?
 
Hi,

No, but VS.NET wizards create all the code you need in this case.
Just drag&drop the table in question on the form, right click on adapter,
generate dataset.
The table should have primary key, of course.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

rkmoray said:
I want to update a table without using a sql statement.
I am hoping for something similar to ado update.

ds.Tables[0].Rows[x] ["authorid"] = "Rick"
ds.update

is something like this possible?
Click to expand...
 
I'm curious why you would want to do so. You may want to consider the
ExecuteNonQuery method of the Command object. That's as close as it gets --
but you would still be executing an INSERT statement ....

rkmoray said:
I want to update a table without using a sql statement.
I am hoping for something similar to ado update.

ds.Tables[0].Rows[x] ["authorid"] = "Rick"
ds.update

is something like this possible?
Click to expand...
 
Back
Top