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

What is static constructor, when it will be fired? And what is its use?

0 Answers  

---

How do you pass value of a text box from page1.aspx to page2.aspx without storing it as a session value?

6 Answers   C Squared Systems,

---

Explain the difference between static page and dynamic page?

0 Answers  

---

What is dot net and its uses?

0 Answers  

---

What are the differences between com architecture and.net architecture?

0 Answers  

---

What's typical about a windows process in regards to memory allocation in .net?

0 Answers  

---

What are the drawbacks for Model-View-Controller Architecture?

1 Answers  

---

What is meant by .Net framework?

1 Answers  

---

What are channels in .NET Remoting?

2 Answers   Rolta,

---

What is MSIL, IL, CTS?

3 Answers  

---

Where does the gac exist ?

0 Answers  

---

What is UDDI and how to register a web service ?

2 Answers   Msoft, TCS,

---