How to Delete a row from dataset ??

[Imayakumar]

Hi ,
i fetched some records from SQL Server using data adapter
and filled it to the dataset. now i want to add some rows
to the dataset and reflect it to the database.. i can do
it perfectly with no problem. but when i try to delete
some rows from the dataset, it gives error..
can any one help how to do this ??
Thanks.
-Imayakumar

[Jagan Mohan]

Deleting DataRow

DataRow[] drDelRows = ds.Tables[0].Select("DELSTATUS = 1");
foreach(DataRow drRow in drDelRows)
{
ds.Tables[0].DeleteRow(drRow);
}

This should work. Can you also give me the details of the error you are
getting.

Thanks,
Jagan Mohan

"Imayakumar" <im******@hotmail.com> wrote in message
news:00****************************@phx.gbl...

Hi ,
i fetched some records from SQL Server using data adapter
and filled it to the dataset. now i want to add some rows
to the dataset and reflect it to the database.. i can do
it perfectly with no problem. but when i try to delete
some rows from the dataset, it gives error..
can any one help how to do this ??
Thanks.
-Imayakumar

[Soni]

have u used the SQlCommandBuilder ..? if not use that and then update ur dataset.