private void sqlDataAdapter1_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
NorthwindDataSet.CustomersRow CustRow = (NorthwindDataSet.CustomersRow)e.Row; MessageBox.Show(CustRow.CustomerID.ToString()
+ " has been updated");
northwindDataSet1.Customers.Clear();
sqlDataAdapter1.Fill(northwindDataSet1.Customers);
}
private void sqlDataAdapter1_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
AdventureWorks2019DataSet.StoreRow CustRow = (AdventureWorks2019DataSet.StoreRow)e.Row;
MessageBox.Show(CustRow.BusinessEntityID.ToString() + " has been updated");
adventureWorks2019DataSet1.Store.Clear();
sqlDataAdapter1.Fill(adventureWorks2019DataSet1.Store);
}
private void sqldaCities_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
if (e.StatementType == StatementType.Insert)
{
UpdatedRowID = (int)e.Row["CityID"];
}
}
/// <summary>
/// See DoNotDuplicateOnInsertPrimaryKey
/// </summary>
static private void OnRowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs args)
{
//MS Bug: The Merge method may create duplicate records when you try to update records with an AutoIncrement field
if (StatementType.Insert == args.StatementType)
{
args.Status = UpdateStatus.SkipCurrentRow;
}
}
private void contratTableAdapter_RowUpdated(Object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
if (e.RecordsAffected == 0)
{
String noContrat = e.Row["conNo"].ToString();
MessageBox.Show("COnflit d'acces concurrentiel pour le contrat " + noContrat + ". Cet enregistrement ne sera ps sauvegarde.", "Conflit d'acces");
}
}
private void sqlDataAdapter1_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
}
private void CustomersAdapter_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)
{
}
