private void buttonUpdate_Click(object sender, EventArgs e) { int searchId = Convert.ToInt32(textBoxClientId.Text); DataRow row = dtClient.Rows.Find(searchId); if (row != null) { row["ClientName"] = textBoxClientName.Text; row["Phone"] = maskedTextBoxPhone.Text; row["CreditLimit"] = float.Parse(textBoxCreditLimit.Text); row["StreetNumber"] = Convert.ToInt32(textBoxCreditLimit.Text); row["StreetName"] = textBoxStreetName.Text; row["City"] = textBoxCity.Text; row["PostalCode"] = textBoxPostalCode.Text; row["Province"] = textBoxProvince.Text; MessageBox.Show("In the DataSet obj, Student Info modified"); } if (dsClient.HasChanges()) //DB { sqlDa = UtilityDB.GetDataAdapterClients(); sqlCmdClient = new SqlCommandBuilder(sqlDa); sqlDa.Update(dsClient.Tables["Clients"]); MessageBox.Show("Database updated successfully.", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void buttonDelete_Click(object sender, EventArgs e) { int deleteId = Convert.ToInt32(textBoxClientId.Text); //delete local DataRow dr = dtClient.Rows.Find(deleteId); if (dr != null) { dr.Delete(); MessageBox.Show("The Client was deleted."); } if (dsClient.HasChanges()) //Update DB { sqlDa = UtilityDB.GetDataAdapterClients(); sqlCmdClient = new SqlCommandBuilder(sqlDa); sqlDa.Update(dsClient.Tables["Clients"]); MessageBox.Show("Database updated successfully.", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information); } }