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

What are the advantages and drawbacks of using ado.net?

1108

---

Which control of the BindingNavigator returns the current position within the data source?

1161

---

What is the difference between a datareader and a dataset?

1027

---

Explain ODP.net

993

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

965

---

What is the use of SqlCommandBuilder?

1202

---

Explain how do you connect to sql server database without using sqlclient?

1000

---

Why edit is not possible in repeater?

940

---

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

1031

---

Explain how to create dynamic gridview?

967

---

What is the difference in an abstract class and an interface?

1005

---

What is DataReader Object?

1035

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

886

---

What is Serialization in .NET? what are the types of Serialization?

1069

---

What is difference between ado.net and asp net?

1034

---