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


}

Is bulk insert faster than insert?

873

---

What do you mean by ‘batch updates’?

994

---

Which is better ole db or odbc?

865

---

What is a non query?

891

---

What is the default provider in ado.net?

923

---

What is the meaning of object pooling?

1146

---

What does ado stand for in ado.net?

1021

---

What is the role of data provider in ado.net?

954

---

Which is faster sqldataadapter and sqldatareader?

880

---

What are the different methods available under the sqlcommand class to access the data?

1011

---

What is ado.net architecture?

889

---

Explain all the classes those are used for database connections between sql server and asp.net?

968

---

What is DataReader Object?

1000

---

What are the classes in System.Data.Common Namespace?

1105

---

What are the methods of XML dataset object?

995

---