Answer Posted / kalirajan

SqlConnection con = new SqlConnection("");
con.Open();
SqlCommand cmd = new SqlCommand("", con);

SqlDataReader dr;

dr = cmd.ExecuteReader();
while (dr.Read())
{
TextBox1.Text = dr[0].ToString();


}

dr.Close();


Try this code...

How to read data with the sqldatareader ?

1028

---

What are the data access namespaces in .NET?

1257

---

What do you mean by performing asynchronous operation using command object?

1088

---

What is ado.net and its architecture?

1263

---

How can you add or remove rows from the datatable object of dataset?

1069

---

Define isolation?

1021

---

What is namespace in ado.net?

1077

---

What is connected architecture in ado.net?

1178

---

Explain ado.net features? Benefits? Drawbacks?

1107

---

Name which operations can you not perform on an ado.net dataset?

1038

---

What is difference between datareader and dataadapter?

1089

---

Describe the disconnected architecture of ADO.NET’s data access model.

1106

---

What is a sqldataadapter?

1053

---

What is the difference between sqlcommand and sqldataadapter?

1033

---

What is a dynaset in access?

1103

---