Answer Posted / sudheer lakkireddy

Take a gridview control in ur design
add
using system.data.sqlclient;
using.system.data;
// give a connection string to database

sqlconnection con= new sqlconnection("conn");

//in button click event write following

sqldataadapter da=new sqldataadapter("select * from
(tablename)",con);
dataset ds=new dataset();
da.fill(ds,"tablename");
gridview1.datasource=ds;
gridview1.datamember="tablename";
gridview1.databind();

try out this

What is openquery?

923

---

What is acid in ado.net?

949

---

What is the meaning of executenonquery?

962

---

What are the ado.net connection pooling parameters?

906

---

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

947

---

What are the parameters that control most of connection pooling behaviours?

1009

---

What is an ado?

935

---

What is executequery?

897

---

What is difference between sqldatareader and sqldataadapter?

892

---

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

979

---

What are the several execute methods of ado.net?

867

---

Explain the namespaces in which .net has the data functionality class.

1009

---

What is the difference between a datareader and a dataset?

938

---

How can we load multiple tables in to dataset?

1030

---

How can we serialize the dataset object?

951

---