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 you mean by filtering of data?

1013

---

Which is faster ado.net or linq?

1063

---

What are all the different methods under sqlcommand?

1029

---

What are the different ado.net namespaces?

1123

---

What is execute reader in ado.net?

1013

---

How do I delete a row from a DataTable?

1229

---

What is untyped dataset?

1141

---

What is ado.net architecture?

969

---

What is sqldatareader?

975

---

What is ole2 format?

963

---

Explain the difference between data reader and data set?

966

---

Which is faster sqldataadapter and sqldatareader?

978

---

What are the different layers of ado.net?

1123

---

What are the ado.net components?

1064

---

What is sql connection in ado.net?

1012

---