syntax for binding the data from database
Answer / 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 |
How to send the Mail in C# using ASP.Net ? And my Answer is as follows ?
What is view state?
Can you edit data in repeater control? How?
What is manifest in .net?
What is the benefit of .net core?
What operating systems does the .net framework run on?
Explain what is the difference between a class and an object?
What is Code group in .Net with respect to CAS
What is a serviced component?
What is typical about a windows process in regards to memory allocation in dot net?
Explain asp.net?
what is the keyword used for self reference?