Delete a row from dataset using delete method???

[SureshRocks]

Hi All, I am new to C# programming with ADO.NET. I tried to delete the specific row but it is not getting affected in the database table. however when i wrote to a XML file, the record seems to be deleted.

SqlDataAdapter da = new SqlDataAdapter("select * from details", con);
DataSet ds = new DataSet();
da.Fill(ds, "details");
DataRow row = ds.Tables["details"].Rows[0];
if (row["Name"].ToString() == fi.Name)
{
ds.Tables["details"].Rows[0].Delete();
da.Update(ds.Tables["details"]);
}
ds.AcceptChanges();

Can any one help me out with an example(C#) for better understanding. Thanks in advance.. Suresh.

[Giorgi Dalakishvili]

Call the Update method

Giorgi Dalakishvili #region signature My Articles Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^] My blog #endregion

[PC Player]

Hi, It seems to be you are trying to delete First Row (Rows[0]), Which you don't want. You have to get specific object of that row and then use Delete command. After that you can update by useing DataAdapter to make permenent delete underling Database. Here is a code which might Help.

foreach (Datarow dr in ds.tables[Customer].rows)
{
// Match condition for specific record
Dr.delete();
break;

}

da.update(ds);

Hope it will help Thanks

Ali Zishan London

[SureshRocks]

Hi, Thanks a lot!!! It's working. Thanks once again, Suresh kumar palleti, India.