Answer Posted / sambhu sankar biswal
Actually There is no syntax to bind data from data base.
to bind data from data base
1st step:-create connection to database
2nd step:-write command
3rd step:-create object of data adapter(oledb/sql)
4th step:-create object of dataset
5th step:-dataadapter's object name.fill(dataset's object name);
6th step:-control name(where u have to bind the
data).DataSource=dataset's object name;
7th step:-control name(where u have to bind the
data).DataBind();
Example:-suppose we need to bind data from "emp" table to
gridview control
Code is bellow:-
Using system.Data.Oledb;//Name space
//inside page load event
OledbConnectionn cn=new
OledbConnection("provider=microsoft.jet.oledb.4.0;data
source=c:/db2.mdb");//complete path of the data base.
OledbCommand cmd=new OledbCommand("select * from emp",cn);
OledbDataAdapter da=new OledbDataAdapter(cmd);
DataSet ds= new DataSet();
da.fill(ds);
GridView1.DataSource=ds;
GridView1.DataBind();
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Compare client server application with n-tier application
What tools is used to develop .NET applications?
What is the difference between .net 2000 and .net 2005(features)? Which one is better?
Is it true that objects don't always get destroyed immediately when the last reference goes away?
Please explain is the jit an interpreter?
What is a serviced component?
Tell us what is a sealed class?
Which namespace is require to used XML in .NET?
Tell us the difference between managed and unmanaged code?
What are the authentication methods in .net?
What is delegation in .net?
Explain the procedure to add assemly to gac to make it shared one?
What is .net code security?
What are Attributes in .NET?
If you are executing these statements in commandobject. Select * from table1; select * from table2? How you will deal result set? 42. How do you sort a dataset.
