Regarding SqlRowUpdateEventHandler

  • Thread starter Thread starter Hyderabadi
  • Start date Start date
H

Hyderabadi

Hi,

I am trying to perform concurrent updates of same record using two
connections and I want to display a message box when this happens.

I am using two connections : in One I hardcode the Update statement on
this record and In the other I use a form to modify the record values
and when save button is clicked the changes must be persisted.

I am using an SqlRowUpdateEventHandler delegate to this use, but its
not firing this event and the corresponding OnRowUpdate Method is also
not getting fired. Instead there is a new record getting added to it.

The code is as follows:

conn = new SqlConnection(connStr);
conn.Open();

/// If user clicks on Save button then save the edited
record back to table
/// through shippingDispatcher form.
if (dr2 == DialogResult.OK)
{
// Create another new connection
SqlConnection conn1 = new SqlConnection(connStr);
try
{
// Open the connection.
conn1.Open();

// Execute the update command by changing the
address field and update the orders table.
string upstr1 = "Update Orders set
Address='updated address' where RecordID = 1";
SqlCommand scmd1 = new SqlCommand(upstr1,
conn1);
scmd1.ExecuteNonQuery();
}
catch (SqlException se3)
{
MessageBox.Show(se3.Message.ToString()+"SQL Exception while
saving edit form details");

}
finally
{ //Close the connection finally
conn1.Close();
}

//Copy the edited contents from edit form into the
datatable denoted by "Orders" in dataset.
dbtble = dset.Tables["Orders"];
dbtble.Rows[gridrow2]["Address"] =
f1.tbEdAddr.Text.Trim();
dbtble.Rows[gridrow2]["Driver"] =
f1.tbEdDriver.Text.Trim();
dbtble.Rows[gridrow2]["City"] =
f1.tbEdCity.Text.Trim();
dbtble.Rows[gridrow2]["State"] =
f1.tbEdState.Text.Trim();
dbtble.Rows[gridrow2]["TimeEntered"] = f1.TimeDate;


//Intialize the adapter with a Selected Command.
SqlCommandBuilder builder = new
SqlCommandBuilder(adapter);
adapter.SelectCommand = new SqlCommand("SELECT *
FROM Orders",conn);
//Get an update command for adapter
adapter.UpdateCommand = builder.GetUpdateCommand();


try
{
adapter.Update(dset, "Orders");
}
catch (SqlException se1)
{
MessageBox.Show(se1.Message + "Update Command
Exception");
}


// Persist the changes made to records into the
database

try
{
adapter.RowUpdated += new
SqlRowUpdatedEventHandler(OnRowUpdated);
adapter.Update(dset, "Orders");
adapter.RowUpdated -= new
SqlRowUpdatedEventHandler(OnRowUpdated);
populateDataGridView();
gridrow2 = 0;

}
catch (Exception sqe)
{
MessageBox.Show(sqe.Message, "Exception while
persisting data.");
}


}
}
}


protected void OnRowUpdated(object source,
SqlRowUpdatedEventArgs args)
{
if (args.RecordsAffected < 1)
{
MessageBox.Show("Error Updating the Record, Record
updated by other User. Plese try again after sometime.");
args.Status = UpdateStatus.Continue;
}
}
 
Back
Top