using Dataadapter to update Database

[ALI-R]

I am using the following code to update my database but it dosn't do the
update and it dosen't show any error:

SqlDataAdapter myDataAdapter=new SqlDataAdapter();

myDataAdapter.SelectCommand=new SqlCommand("select * from Alerts",conn);

DataSet alertDS = new DataSet();

myDataAdapter.FillSchema(alertDS,SchemaType.Source ,"Alerts");

myDataAdapter.Fill(alertDS);

DataTable myTable = alertDS.Tables[0];

foreach(DataRow myDRow in myTable.Rows)

{

sb.Append((String)(myDRow["Message"]));

myDRow["Viewed"]=1;
}

myDataAdapter.Update(alertDS,"Alerts");

=====End of code=====================

if I remove this line from code :

myDataAdapter.FillSchema(alertDS,SchemaType.Source ,"Alerts");

it gives me this error on the update on the adapter:

update requires a valid Update Command when passed DataRow collection with
modified rows

Is there somebody who can help me.

Thanks

[Ranjan]

Hi ALI
For SqlDataadapter.Update() to work, you will need to set the
UpdateCommand property of the SqlDataAdapter object.
HTH.
r.

"ALI-R" <al*@microsoft.com> wrote in message
news:et**************@TK2MSFTNGP12.phx.gbl...

I am using the following code to update my database but it dosn't do the
update and it dosen't show any error:

SqlDataAdapter myDataAdapter=new SqlDataAdapter();

myDataAdapter.SelectCommand=new SqlCommand("select * from Alerts",conn);

DataSet alertDS = new DataSet();

myDataAdapter.FillSchema(alertDS,SchemaType.Source ,"Alerts");

myDataAdapter.Fill(alertDS);

DataTable myTable = alertDS.Tables[0];

foreach(DataRow myDRow in myTable.Rows)

{

sb.Append((String)(myDRow["Message"]));

myDRow["Viewed"]=1;
}

myDataAdapter.Update(alertDS,"Alerts");

=====End of code=====================

if I remove this line from code :

myDataAdapter.FillSchema(alertDS,SchemaType.Source ,"Alerts");

it gives me this error on the update on the adapter:

update requires a valid Update Command when passed DataRow collection with
modified rows

Is there somebody who can help me.

Thanks