rendered paste body private void btnSaveChanges_Click(object sender, EventArgs e)
{
int rowCount;
DataSet allProductData = new DataSet();
allProductData.ReadXml("Products.xml", XmlReadMode.ReadSchema);
SmartMartClassLibrary.SmartMart Service = new SmartMartClassLibrary.SmartMart();
try
{
foreach (DataRow row in allProductData.Tables["Products"].Rows)
if (int.Parse(row["Dirty"].ToString()) == 1)
rowCount = Service.UpdateProducts(int.Parse(row["ProductID"].ToString()), row["BrandName"].ToString(), row["ProductName"].ToString(), double.Parse(row["SRP"].ToString()), double.Parse(row["GrossWeight"].ToString()), double.Parse(row["NetWeight"].ToString()), double.Parse(row["ShelfWidth"].ToString()), double.Parse(row["ShelfHeight"].ToString()), double.Parse(row["ShelfDepth"].ToString()));
if (rowCount = 0)
MessageBox.Show("No rows could be updated");
else
MessageBox.Show("Rows were updated");
}
catch (Exception ex)
{
MessageBox.Show("The following error occured " + ex.Message);
}
MessageBox.Show("Update complete");
}