Answer / kalirajan

ADO.NET Obj:

SqlConnection
SQlcommand
SqlDataReader
SqlDataAdapter
Dataset


Retrieving Data:

SqlConnection con = new SqlConnection("");
con.Open();
SqlCommand cmd = new SqlCommand("select * from Tbl", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

How do you connect to sql server database without using sqlclient?

0 Answers  

---

What is the difference between data grid and data repeater?

0 Answers  

---

Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,

---

How do I delete a row from a DataTable?

0 Answers   UGC Corporation,

---

What are the steps in connecting to database ?

2 Answers   Microsoft,

---

Where is adodb dll located?

0 Answers  

---

What are the Different layers in ADO.Net?

10 Answers   eXensys,

---

How can we add relation between tables in a dataset?

0 Answers  

---

What is a sqldataadapter?

0 Answers  

---

Does dapper use ado.net?

0 Answers  

---

What is the use of connection object in ado.net?

0 Answers   TryTechnicals Pvt Ltd,

---

What are the difference between readonly vs. Const?

0 Answers  

---