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 form description?
How to get records from a database?
What is the extension of a compiled help project file?
What is form and its uses?
how see report periviwe
Are windows forms still used?
What are the forms of database?
What is a windows form application?
Which event occurs when a user drags an item in a treeview or listview control?
What is window form application?
What are the components of gui for windows?
What is the use of runworkasync() methods?
Which command prompt utility is used to convert a resource file from the text format into the binary format?
What is form design?
Name the property which of menu cannot be set at run time?