Answer / ajrun

Dim Query
Query="insert into TableName(username)values('" &
txt_username.text & "')"
Dim cmd as sqlclient.sqlcommand=new
sqlclient.sqlcommand(Query,connection)
cmd.ExecuteNonquery()

Answer / vishnu

System.Data.SqlClient.SqlConnection sqlConnection1 =
new System.Data.SqlClient.SqlConnection("YOUR CONNECTION
STRING");

System.Data.SqlClient.SqlCommand cmd = new
System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT Region (RegionID,
RegionDescription) VALUES (5, 'NorthWestern')";
cmd.Connection = sqlConnection1;

sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();

Answer / 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...

Answer / y.gangi reddy

SqlConnection cn = new SqlConnection("user id=sa;pwd=xxx;database=yyy;data source=.");
SqlDataAdapter da = new SqlDataAdapter("select * from tablename", cn);
DataSet ds = new DataSet();
da.Fill(ds, "tablename");

What is form technology?

0 Answers  

---

We are facing problem with the compatibilty of IE 7 and IE 6.We are calling a showModal window that is working fine in IE6 but with IE7 it opens a new Window and Data is not getting poputaled.In some pages it Gives an error "The webpage you are viewing is trying to Close the window.Do you want to close this window".

1 Answers   Wipro,

---

What is the extension of the windows installer file?

0 Answers  

---

Which window allows viewing the resources of the servers, such as services, processes and the event log?

0 Answers  

---

Is it possible to save view state on the web server?

1 Answers   Arctern,

---

What are windows based applications examples?

0 Answers  

---

Which property value of the helpnavigator property will display the index for a specified topic?

0 Answers  

---

Which event occurs when a user drags an item in a treeview or listview control?

0 Answers  

---

What is form and its uses?

0 Answers  

---

Is windows an application software?

0 Answers  

---

Which dialog box allows users to switch to another area of the application?

0 Answers  

---

What is boxing and how it is done internally?

4 Answers   Microsoft,

---