syntax for binding the data from database

Question Posted / sudha_2a3

1 Answers
4522 Views
Satyam, I also Faced
E-Mail Answers

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

Post New Answer

More Dot Net General Interview Questions

Should I implement finalize on my class? Should I implement idisposable?

0 Answers

What is Custom attribute? How to create? Namespace? If I'm having custom attribute in an assembly, how to say that name in the code? What is Reflection in .NET?

3 Answers Accenture, CC Soft, Infosys,

Is there a way to suppress the finalize process inside the garbage collector forcibly in .net?

0 Answers

What is Meta Data? Explain Types of Assemblies

2 Answers Deloitte,

If we write any code for DataGrid methods, what is the access specifier used for that methods in the code behind file and why?

0 Answers

Class for getting the info that is on clipboard of our system in a windows App?

1 Answers

Explain assemblies in .net?

0 Answers

Difference between user groups and code groups