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();

What is ole db and odbc?

926

---

What is difference between executenonquery and executequery?

980

---

What are the advantage of ado.net?

999

---

What are the important features of ado.net 2.0?

1076

---

How can we add relation between tables in a dataset?

1000

---

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

983

---

What is ado and dao?

960

---

Can datareader hold data from multiple tables?

1182

---

What does executenonquery () method return?

939

---

Which object needs to be closed?

2263

---

What is different between sqlcommand object and command behavior object?

1063

---

Explain the two fundamental objects in ado.net?

993

---

What is ado.net object model?

988

---

What are the different ado.net namespaces?

1069

---

What is sql connection in ado.net?

950

---