Database

<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 />

DataSet m_xmlData = new Dataset("Modules");
m_xmlData.Clear();
m_xmlData.ReadXml("thisfile.xml");

int tableCount = m_xmlData.Tables.Count;
for (int i = 0; i < tableCount; i++)
{
    DataTable dt = m_xmlData.Tables[i];
    if (dt.TableName != "Module")
    {
        continue;
    }
    int rowCount = dt.Rows.Count;
    for (int j = 0; j < rowCount; j++)
    {
        DataRow row = dt.Rows[j];

    }
}