MySql.Data.MySqlClient.MySqlDataAdapter.Update C# (CSharp) Метод

Update() защищенный Метод

protected Update ( DataRow dataRows, DataTableMapping tableMapping ) : int
dataRows System.Data.DataRow
tableMapping System.Data.Common.DataTableMapping
Результат int
        protected override int Update(DataRow[] dataRows, DataTableMapping tableMapping)
        {

            List<MySqlConnection> connectionsOpened = new List<MySqlConnection>();

            try
            {
                // Open connections for insert/update/update commands, if 
                // connections are closed.
                foreach(DataRow row in dataRows)
                {
                    OpenConnectionIfClosed(row.RowState, connectionsOpened);
                }

                int ret = base.Update(dataRows, tableMapping);

                // Following was a workaround for Bug#54863
                // It  a good question whether we still needed it, it seems like
                // .NET bug (DbDataAdapter not issuing AcceptChanges() for 
                // modified rows) has already been fixed in .NET
                foreach (DataRow row in dataRows)
                {
                    if (row.RowState != DataRowState.Unchanged &&
                        row.RowState != DataRowState.Detached)
                    {
                        row.AcceptChanges();
                    }
                }

                return ret;
            }
            finally 
            {
                foreach(MySqlConnection c in connectionsOpened)
                    c.Close();
            }
        }

Usage Example

        /// <summary>
        /// Initializes a new instance of the <see cref="ManagerAddExistingItemGui"/> class.
        /// </summary>
        /// <param name="jobID1">The job i d1.</param>
        public ManagerAddExistingItemGui(string jobID1)
        {
            this.jobID = jobID1;
            InitializeComponent();
            this.WindowStartupLocation = WindowStartupLocation.CenterScreen;
            jobid_label.Content = jobID;

            try
            {
                MySqlConnection MySqlConn = new MySqlConnection(Login.Connectionstring);
                MySqlConn.Open();
                string Query1 = ("select itemid as `מקט פריט`,itemName as `שם פריט`, item_discription as `תאור פריט` from project.item WHERE itemStatus='בעבודה' group by itemid");
                MySqlCommand MSQLcrcommand1 = new MySqlCommand(Query1, MySqlConn);
                MSQLcrcommand1.ExecuteNonQuery();
                MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(MSQLcrcommand1);
                //DataTable dt1 = new DataTable("items");
                mysqlDAdp.Fill(dt);
                Create_DataTable1_Columns_End();
                //   Make_CheckBox1_Columns_False();
                dataGrid1.ItemsSource = dt.DefaultView;
                mysqlDAdp.Update(dt);

                MySqlConn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
All Usage Examples Of MySql.Data.MySqlClient.MySqlDataAdapter::Update