Hi, I am implementing one windows form. I am inserting some
values into ms access. In that table 5 columns there. But I
want to insert three columns only. when I am clicking
another button then other two values also insert into that
table. please help me
Answers were Sorted based on User's Feedback
Answer / karthik
1st button
Insert into table names (@column1,@column2,@column3,'','')
2nd button
update tablename set column4=@column4,column5=@column5
where column1=@column1 and column2=@column2 and
column3=@column3
hope it will help
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / balaji
first time insetr five columns but two columns are empty
value thats null value when we click another button update
query is used insert remaining columns (where condition
filled columns value)
Is This Answer Correct ? | 8 Yes | 0 No |
what are container objects?
What is the difference between the add() and insert() methods of a listbox control?
What are the forms of database?
Suppose I am implementing one windows form. I am inserting some values into ms access. In that table 5 columns there. But I want to insert three columns only. When I am clicking another button then other two values also insert into that table?
What are the different types of indexes in SQL Server?
What is form and its types?
Which controls can not be placed in MDI ?
Which interface is to be implemented to release the unmanaged resources in an object in Dot Net?
What is the default property of data control?
What is the difference between pixels, points, and em’s when fonts are displayed?
What are controls in windows forms?
Which property is used to specify the use of an element in the user interface and reports it to the accessibility aids?