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 is execute scalar in ado.net?

900

---

How many major types of connection objects in ADO.NET?

988

---

What connected data?

890

---

What are the Features and disadvantages of dataset

1034

---

What is maximum pool size in ado.net connection string?

926

---

Define data adapter?

893

---

Define partial class?

900

---

What is the role of the dataset object in ado.net?

1056

---

What is ado.net tutorial?

865

---

How to pass values into a datatable?

1056

---

What is adodb dll?

950

---

What is ado.net in mvc?

871

---

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

959

---

What are the advantages of ado.net?

851

---

What is the difference between executequery and executenonquery?

867

---