Answer Posted / muthu kumar

DataSet ds = new DataSet();
ds.Load(cmd.ExecuteReader(),
LoadOption.OverwriteChanges, "sample");

DataRow[] dr = ds.Tables[0].Select("id>1 and id<10");

for (int i = 0; i < dr.Length; i++)
{
Response.Write(dr[i][0].ToString()+"<br>");


}

Which provider is used to connect ms access, oracle, etc…?

1004

---

How can we save all data from dataset?

1004

---

Define partial class?

973

---

What is difference between ado.net and asp net?

1043

---

Which database is the ado.net sql connection object designed for?

1050

---

What is read only and forward only in ado.net?

943

---

What are dcl commands?

1009

---

What are the ado.net components?

1017

---

What are the difference between readonly vs. Const?

1012

---

How will you fill the gridview by using datatable object at runtime?

1058

---

What are the ado.net objects?

944

---

Give an example that shows how to execute a stored procedure in ado.net?

1074

---

Define Execute Reader?

1069

---

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

1014

---

Why is it important to close an ado.net application?

1024

---