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

Explain the overview of ado.net architecture?

1035

---

How to read data with the sqldatareader ?

970

---

What is a non query?

921

---

What is sql connection in ado.net?

941

---

What is connected architecture in ado.net?

1055

---

What is openrowset?

974

---

Which is faster ado.net or linq?

1014

---

What is a control toolbox?

961

---

What are the key features of ado.net?

1192

---

What is ado connection?

945

---

Which is faster entity framework or ado.net?

923

---

What are good ado.net object to replace to ado recordset object.

1114

---

What are the types of databinding?

985

---

Which method is used by command class to execute SQL statements that return single value?

1041

---

List the 4 common ado.net namespaces?

1160

---