Answer Posted / ramakrushna

SqlConnection con = new SqlConnection();
con.ConnectionString = "server=munapc;
database=project1; User ID=sa; Password=niit";
con.Open();

string query = "select * from emp";
SqlDataAdapter da = new SqlDataAdapter(query, con);
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;

con.Close();

What is ado.net full form?

751

---

how we can fire event in databound coulm in datagfrid withot using button?

750

---

Explain the difference between data reader and data adapter?

711

---

Which object needs to be closed?

1988

---

Describe briefly an ADO.NET Dataset ?

751

---

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

769

---

What is ado data control?

741

---

Explain what are acid properties?

763

---

What are the essential features of ado.net?

723

---

What is difference between executenonquery and executequery?

706

---

differences between ADO and ADO.NET

804

---

What is data access pattern?

675

---

Describe datareader object of ado.net with example.

702

---

What is the difference between oledb sql server and oledbdotnet provider?

740

---

What is ado.net explain with diagram?

718

---