Answer Posted / venky
string cns=@"server=.\SQLEXPRESS;Database=emp;Integrated Security=SSPI";
cn=new SqlConnection(cns);
string sql = "select * from mytable";
DataSet ds = new DataSet();
SqlDataAdapter adpt=new SqlDataAdapter(sql,cn);
adpt.Fill(ds,"emp1");
.....after altering table....
sqlcommandbuilder cbdr=new sqlcommandbuilder(adpt);
adpt.Update(ds,"emp1");
your changes automaically save into databases...
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is formdata?
What are the properties of datacontrol?
how print barcode
Explain how many number of events does the timer controls?
What is the use of form?
What are controls in windows forms?
What are window based applications?
What are the three states set in a checkstate property?
Which of the following position is the default docking position of the statusstrip control on the form?
What is form and meaning?
What is form application?
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?
how barcode print on the win form
What is the difference between pixels, points, and em’s when fonts are displayed?
Explain the new events in textbox that has been included in vb?