Answer Posted / sandeep singh shekhawat

Solution1:
SqlConnection con=new SqlConnection("Data Source=./SqlExpress;Database=Test;Integrated Security= true;")
SqlDataAdapter adp=new SqlDataAdapter("insert into employee values(@Id,@Name)",con);
dap.SelectCommand.Parameters.AddwithValue("@Id",TextBox1.Text);
dap.SelectCommand.Parameters.AddWithValue("@Name",TextBox2.Text);

for this sql Connection define globally and after that all code write on button click event.


Solution2
SqlConnection con=new SqlConnection("Data Source=./SqlExpress;Database=Test;Integrated Security= true;")
SqlCommand cmd=new SqlCommand("insert into emp values(@Id,@Name)",con)
cmd.Parameter.AddWithValue("@Id",TextBox1.Text);
cmd.Parameter.AddwithValue("@Name",TextBox2.Text);
if(con.State==ConnectionState.Closed)
con.Open();
cmd.ExecuteNonQuery();

How do you update a dataset in ado.net and how do you update database through dataset?

922

---

Which method is used to sort the data in ADO.Net?

1973

---

What is the functionality of data provider in ado.net?

937

---

What is dbcontext and dbset in entity framework?

934

---

Can we load multiple tables in a dataset?

1126

---

What is the difference between OLEDB Provider and SqlClient?

981

---

What is ado.net components?

959

---

What are the data access namespaces in .NET?

1203

---

Which database is the ado.net?

966

---

What is difference between entity framework and ado.net?

927

---

Define partial class?

952

---

What is sqldatareader?

914

---

Explain the difference between an ado.net dataset and an ado recordset?

1057

---

Which object is used to add relationship between two Datatables?

1041

---

What is the usage of the dataset object in ado.net?

958

---