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 are the advantages of form?

0 Answers  

---

How to get records from a database?

0 Answers  

---

How do I change the console application in windows?

0 Answers  

---

how find recored from the database

2 Answers   Wipro,

---

Which template creates a .net compact framework 2.0 forms application for pocket pc 2003 and later?

0 Answers  

---

Which property of the progressbar control specifies the amount to increment the current value of the control?

0 Answers  

---

If you are calling three SPs from a window application how do u check for the performance of the SPS ?

1 Answers   Accenture, BirlaSoft,

---

What is the difference between a document and a form?

0 Answers  

---

What are windows applications?

0 Answers  

---

What are the different types of indexes in SQL Server?

3 Answers   Arctern,

---

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

0 Answers  

---

For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this?

1 Answers   Microsoft,

---