Esempi in C# (CSharp) per System.Data.SqlClient.SqlRowUpdatingEventArgs

Esempio n. 1

        private void sqlDataAdapter1_RowUpdating(object sender, System.Data.SqlClient.SqlRowUpdatingEventArgs e)
        {
            AdventureWorks2019DataSet.StoreRow CustRow = (AdventureWorks2019DataSet.StoreRow)e.Row;
            DialogResult response = MessageBox.Show("Continue updating " + CustRow.BusinessEntityID.ToString() + "?", "Continue Update?", MessageBoxButtons.YesNo);

            if (response == DialogResult.No)
            {
                e.Status = UpdateStatus.SkipCurrentRow;
            }
        }

Esempio n. 2

File: Form1.cs Progetto: oplugin/ITMO.ADO.NET

        private void sqlDataAdapter1_RowUpdating(object sender, System.Data.SqlClient.SqlRowUpdatingEventArgs e)
        {
            NorthwindDataSet.CustomersRow CustRow = (NorthwindDataSet.CustomersRow)e.Row;
            DialogResult response = MessageBox.Show("Continue updating " + CustRow.CustomerID.ToString() + "?", "Continue Update?", MessageBoxButtons.YesNo);

            if (response == DialogResult.No)
            {
                e.Status = UpdateStatus.SkipCurrentRow;
            }
        }