Thread: windows form using C#.net

Hi, I am developing one windows form using C#.net. I am inserting some values into SQl database. In that table five columns there. But I would like to insert three columns only. When I am clicking another button then reaming two values also insert into that table. I am not getting any solution for my problem and need some help for solving that problem.

• first button

Insert into table names (@column1, @column2, @column3,'',''...)

• second button

Update tablename set column4=@column4,column5=@column5 where column1=@column1 and column2=@column2 and column3=@column3

Hope it will fix your problem.

First of all insert 5 columns but 2 columns are empty value that’s null value when we click another button update query is used insert remaining columns (use where condition)