HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND
PROGRAMING?
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();
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
how Sequence to connect and retrieve data from database using dataset?
Is it possible to edit data in Repeater control?
Describe the disconnected architecture of ADO.NET’s data access model.
What is ole data type?
How do you implement locking concept for dataset?
What is execute reader in ado.net?
What is difference between Dataview and Datatable?
What are datareaders?
What does ado stand for?
What is ado asp?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is ado.net code?
What does executereader return?
What is dataadapter in ado.net?
What are the key features of ado.net?