public void populateRecords()
{
DatabaseLayer.DBOperations dbOperations = new DatabaseLayer.DBOperations();
try {
_sqlDataAdapter = dbOperations.RetrieveRecord(_sqlDataAdapter);
_sqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
_dataSet = new DataSet();
_sqlDataAdapter.Fill(_dataSet, Common.DATA_TABLE_PRODUCTS);
}
catch (Exception e) {
MessageBox.Show(e.ToString(), Common.APPLICATION_NAME,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//display the product information to the dataGridView
dataGridViewProducts.DataSource = _dataSet.Tables[Common.DATA_TABLE_PRODUCTS];
}
private void saveChangesDatbase()
{
try {
//int rows = _sqlDataAdapter.Update(_dataSet, Common.DATA_TABLE_PRODUCTS);
DatabaseLayer.DBOperations dbOperations = new DatabaseLayer.DBOperations();
string rows = dbOperations.SaveChangesDatabase(_sqlDataAdapter, _dataSet);
if (isNumeric(rows))
{
MessageBox.Show(string.Format(Common.MESSAGE05_DATA_SUCCESSFUL_DATABASE, rows), Common.APPLICATION_NAME,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(rows, Common.APPLICATION_NAME,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception e) {
MessageBox.Show(e.ToString(), Common.APPLICATION_NAME,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
