Database

using (DataSet ds = new DataSet())
using (SqlConnection conn = new SqlConnection(connectionString))
using (SqlDataAdapter da = new SqlDataAdapter("select * from TableName", conn))
{
                
    try
    {
        da.Fill(ds);
        ds.ReadXml(@"C:\xmldataset.XML");
        ds.AcceptChanges();
        da.Update(ds);
    }
                [...]

<br />
  BEGIN TRANSACTION<br />
      BEGIN<br />
         SELECT  data<br />
      END<br />
      BEGIN<br />
         UPDATE status=4<br />
      END<br />
     IF @@ERROR <> 0<br />
        BEGIN<br />
             -- Rollback the transaction<br />
         ROLLBACK  <br />
         RETURN -1<br />
       END<br />
COMMIT<br />