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

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.