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 oledb and odbc?

945

---

What are the types of databinding?

993

---

What is Data Provider?

1052

---

What is the full form of ado?

1013

---

What are the usages of the command object in ado.net?

1024

---

What are all components of ADO.Net data provider?

1060

---

What is the difference between ado.net and entity framework?

1050

---

What does sqldatareader return?

965

---

How to read data with the sqldatareader ?

983

---

What is aggregate root?

1105

---

What is the difference between ado.net and oledb?

952

---

What are all features of ADO.Net?

984

---

Define atomicity?

1032

---

What is difference between entity framework and ado.net?

930

---

What is the use of ADO.NET and XML web services?

1047

---