Combo box; Add New; Save; Delete Buttons

[Kappucino XL]

Hi there, I have created a windows form application where I've placed a combo box; a load button and three data-grids. All these receive their data from a SQL Database. The combo box from table1. The three data grids from table 2, 3, and 4. Now when I click the load button data in the database is displayed in the respective controls. What I need now , is the code for the Add New button to clear the controls ; the delete button, to delete the record with the focus on it ; the save button to save the newly added record to the database. Please Help... :-(

[MrMancunian]

What did you try yourself so far?

Steven

[Kappucino XL]

@MrMancunian
Well, since my load button(whichwor kks) code is :
this.table1Tabl eAdapter.Fill(t his.tableDataSe t.Categorytable );
this.table2Tabl eAdapter.Fill(t his.table2DataS et.Categorytabl e);
this.table3Tabl eAdapter.Fill(t his.table3DataS et.Categorytabl e);
this.table4Tabl eAdapter.Fill(t his.table4DataS et.Categorytabl e);

I tried replacing yhe word "Fill", with Delete, for the Delete Button ; and ClearBefore Fill for the AddNew Button.

For my save Button, I used :
this.Validate() ;
this.table1Bind ingSource1.EndE dit();
this.table2Bind ingSource.EndEd it();
this.table3Bind ingSource.EndEd it();
this.table4Bind ingSource.EndEd it();
this.tableAdapt erManager.Updat eAll(this.Datab aseDataSet);

Hope I'm on the right track... :-(