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
Explain me what is .net web service?
Please explain what is heap and what is stack?
What are the new features in .net core?
Explain me what is encapsulation?
Please explain what is reflection and what is it for?
Explain how garbage collection works?
What is the concept of inheritance in .net?
What is data type and how many types of data types are in .NET ?
What is the difference between user control an custom control? Advantages/disadvantages?
What is web.config in .net?
Do you know what is linq?
What is a variable of implicit type and what is its scope?
How to use datagrid value in select statements where condition ,if cell is hyperlink bounded column?
What are the main components in .net?
What is lazy initialization?