To create a new record, the user will fill in the fields and press the New button. This will fire the btnNew_Click event, which is tied to the btnNew_Click event handling method. In the event handler, call DataTable.NewRow( ), which asks the table for a new DataRow object. This is very elegant because the new row that the DataTable produces has all the necessary DataColumns for this table. You can just fill in the columns you care about, taking the text from the user interface (UI). Now that the row is fully populated, just add it back to the table. The table resides within the DataSet, so all you have to do is tell the DataAdapter object to update the database with the DataSet and accept the changes. Next, update the user interface, you can now repopulate the list box with your new added row and clear the text fields so that you're ready for another new record
The Following is the Code Snippet:
// Handle the ADD button click
protected void btnAdd_Click (object sender, System.EventArgs e)
{
// Create a new row, populate it with entered
// Data from the ListBox
DataRow newRow = _dataTable.NewRow();
newRow["CustomerID"] = txtCompanyID.Text;
newRow["CompanyName"] = txtCompanyName.Text;
newRow["ContactName"] = txtContactName.Text;
newRow["ContactTitle"] = txtContactTitle.Text;
newRow["Address"] = txtAddress.Text;
newRow["City"] = txtCity.Text;
newRow["PostalCode"] = txtZip.Text;
newRow["Phone"] = txtPhone.Text;
// Add the new row to the table in the dataset
dataTable.Rows.Add(newRow);
// Update the database, any Error is catched in catch block
try
{
// Prepared UPDATE Command is executed
dataAdapter.Update(_dataSet,"Customers");
dataSet.AcceptChanges();
// Inform the user and repaint Form
lblMessage.Text = "Updated!";
Application.DoEvents();
// Repopulate the list box
PopulateListBox();
// Clear all the text fields
ClearFields();
}
catch (SqlException ex)
{
_dataSet.RejectChanges();
MessageBox.Show(ex.Message);
}
}
|
No responses found. Be the first to respond and make money from revenue sharing program.
|