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 ado.net full form?

1039

---

What is disconnected data?

1093

---

Explain how to find the given query is optimised one or not?

1097

---

What are the ado.net components?

1073

---

What is the significance of CommandBehavior.CloseConnection ?

1213

---

What is sql connection in ado.net?

1016

---

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

1088

---

What are the Features and disadvantages of dataset

1176

---

What are the major challenges in accessing data from a database?

1068

---

What is the difference between Dataset. clone and Dataset.copy?

1097

---

how Sequence to connect and retrieve data from database using dataset?

1355

---

What is microsoft ado?

1075

---

What is row state?

1039

---

What is the difference between a datareader and a dataset?

1102

---

Explain the difference between an ado.net dataset and an ado recordset?

1114

---