1:
2:
3:
4:
5:

        private void dataGridView_EingabeKategorie_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
        {
            int i1 = e.RowIndex;
            this.kategorieTableAdapter.Insert((string)this.dataGridView_EingabeKategorie.Rows[i1].Cells["kategorie_name"].Value, (bool)this.dataGridView_EingabeKategorie.Rows[i1].Cells["kategorie_typ"].Value);    
        }                    

1:
2:
3:
4:
5:

        private void dataGridView_EingabeKategorie_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            int i1 = e.RowIndex;
            this.kategorieTableAdapter.Update((string)this.dataGridView_EingabeKategorie.Rows[i1].Cells["kategorie_name"].Value, (bool)this.dataGridView_EingabeKategorie.Rows[i1].Cells["kategorie_typ"].Value, (int)this.dataGridView_EingabeKategorie.Rows[i1].Cells["kategorie_id"].Value); 
        }                    

1:
2:
3:
4:
5:

private void saveButton_Click(object sender, EventArgs e)
{
    myBindingSource.EndEdit();
    kategorieTableAdapter.Update(kategorieTable);
}                    

1:
2:
3:
4:
5:

        private void btnSpeichern_Click(object sender, EventArgs e)
        {
            kategorieBindingSource.EndEdit();
            kategorieTableAdapter.Update(this.haushaltDataSet.kategorie);
        }                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

public virtual int Insert(string kategorie_name, bool kategorie_typ) {
            if ((kategorie_name == null)) {
                throw new global::System.ArgumentNullException("kategorie_name");
            }
            else {
                this.Adapter.InsertCommand.Parameters[0].Value = ((string)(kategorie_name));
            }
            this.Adapter.InsertCommand.Parameters[1].Value = ((bool)(kategorie_typ));
            global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
            if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open) 
                        != global::System.Data.ConnectionState.Open)) {
                this.Adapter.InsertCommand.Connection.Open();
            }
            try {
                int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
                return returnValue;
            }
            finally {
                if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
                    this.Adapter.InsertCommand.Connection.Close();
                }
            }
        }                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:

public virtual int Update(string kategorie_name, bool kategorie_typ, int kategorie_id) {
            if ((kategorie_name == null)) {
                throw new global::System.ArgumentNullException("kategorie_name");
            }
            else {
                this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(kategorie_name));
            }
            this.Adapter.UpdateCommand.Parameters[1].Value = ((bool)(kategorie_typ));
            this.Adapter.UpdateCommand.Parameters[2].Value = ((int)(kategorie_id));
            global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
            if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open) 
                        != global::System.Data.ConnectionState.Open)) {
                this.Adapter.UpdateCommand.Connection.Open();
            }
            try {
                int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
                return returnValue;
            }
            finally {
                if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
                    this.Adapter.UpdateCommand.Connection.Close();
                }
            }
        }                    

1:

INSERT INTO Kategorie (ID, Name...) VALUES (@ID, @Name ...)                    

1:

UPDATE Kategorie SET ID = @ID, Name = @Name ... WHERE ...