Write steps of retrieving data using ado.net ?
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
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is a string variable?
What are the key features of ado.net?
What is two way data binding android?
What are the different methods by which we can populate a dataset?
What are the different row versions available in table?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Does executenonquery return a value?
How can we save all data from dataset?
What is ado control?
What is fill method in ado.net?
What is the meaning of object pooling?
What are good ado.net object to replace to ado recordset object.
Explain the two fundamental objects in ado.net?
What is ado.net connection?
What is the difference between sqldatareader and sqldataadapter?