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();

How to get the hostname or IP address of the server?

2 Answers  

---

Why do we use msmq?

0 Answers  

---

What is the difference between VB and VB.NET?

2 Answers  

---

What is nmake tool?

1 Answers  

---

How many types of exception handlers are there in .NET?

2 Answers  

---

---

What is .net and .net framework?

0 Answers  

---

Explain how to spawn a thread?

0 Answers  

---

Whate are resource files?

0 Answers  

---

Is .net is platform independent. If am using solaris, installing .net first u had to install framework, so framework is .exe file then it will not take in solaris or any other than windows,then how .net is platform independent.

1 Answers  

---

How do you turn off cookies for one page in your site? Give an example.

0 Answers  

---

What is Full trust permission set in .Net

0 Answers  

---

Which is the main Difference Between .Net 2003 and .Net 2005?

1 Answers  

---