SQLDataAdapter Update Error

[rkbnair]

--------------------------------------------------------------------------------

I have a problem in updating certain data in an SQL table.
Hope, I have the right syntax. It accepts the commands. However, the data is
never updated.

Placed below is the code.

Thanks.

================================================== ========
mycn.Open();
myda = new SqlDataAdapter ("SELECT
lng_id,lng_clientid,str_mail_from,str_mail_to FROM web_tbl_emails", mycn);

ds = new DataSet();
myda.Fill (ds,"Table");

foreach(DataRow row in ds.Tables [0].Rows )
{
row.ItemArray.SetValue(System.DateTime.Now.ToStrin g()+1,10);
row.ItemArray.SetValue("test1",2);
row.ItemArray.SetValue("test2",3);
myda.Update (ds,"web_tbl_emails");
}

[Steve Goodyear]

You need to create an update command to tell the data adapter the SQL
statements to pass to the database to update the data.

....
myda.UpdateCommand = new SqlCommand();
myda.UpdateCommand.CommandText = "UPDATE web_tbl_emails SET ...";
....
foreach(DataRow row in ds.Tables [0].Rows )
{
// make your changes
}
// move the update call outside the foreach loop to update all at once:
myda.Update (ds,"web_tbl_emails");

http://msdn.microsoft.com/library/en...mmandtopic.asp

Cheers,
Steve Goodyear

[Steve Goodyear]

You need to create an update command to tell the data adapter the SQL
statements to pass to the database to update the data.

....
myda.UpdateCommand = new SqlCommand();
myda.UpdateCommand.CommandText = "UPDATE web_tbl_emails SET ...";
....
foreach(DataRow row in ds.Tables [0].Rows )
{
// make your changes
}
// move the update call outside the foreach loop to update all at once:
myda.Update (ds,"web_tbl_emails");

http://msdn.microsoft.com/library/en...mmandtopic.asp

Cheers,
Steve Goodyear

[Cor Ligthert]

Rob,

for this simple one you can beside writing your own update command as well
use the commandbuilder.

ds = new DataSet();
myda.Fill (ds,"Table");
SqlCommandBuilder cmb = new SqlCommandBuilder(myda);
foreach(DataRow row in ds.Tables [0].Rows )
{

..............

I hope this helps,

Cor

[Cor Ligthert]

Rob,

for this simple one you can beside writing your own update command as well
use the commandbuilder.

ds = new DataSet();
myda.Fill (ds,"Table");
SqlCommandBuilder cmb = new SqlCommandBuilder(myda);
foreach(DataRow row in ds.Tables [0].Rows )
{

..............

I hope this helps,

Cor