Answer Posted / sai_sanju84@yahoo.com

we can fill grid view by using sqldataadapter and dataset.
the code will be as follows........

using System.data.sqlclient (add namespace)

in code part....

sqlconnection con=new sqlconnection("server=(the server
which u use);database=(database in which your table
located);user id=;password=");

sqldataadapter da=new sqldataadapter("select * from
table",con);
dataset ds=new dataset();
da.fill(ds);
gridview1.datasourse=ds;
gridview1.databind();

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1097

---

What is sqldatasource?

975

---

What are the Features of a dataset

1371

---

What is difference between connected and disconnected architecture in ado.net?

1201

---

What is the purpose of using adodb?

1010

---

Does dapper use ado.net?

1068

---

Why is ADO.NET serialization slower than ADO ?

1099

---

What providers does Ado.net uses?

1060

---

What is the advantage of ado.net?

1060

---

How do you implement locking concept for dataset?

1040

---

What is serialization and de-serialization in .net? How can we serialize the dataset object?

1013

---

What is an ado?

1027

---

What are the data access namespaces in .NET?

1256

---

What are the connected and disconnected modes in ado.net?

961

---

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

2077

---