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

when web.config file is being called or referenced?tell me about the searialized procedure followed in page loading.

1 Answers   AZTEC,

---

what is AGILE SCRUM methodoly....?

1 Answers  

---

What is marshling?

0 Answers  

---

When displaying fonts, what is the difference between pixels, points and ems?

0 Answers  

---

Explain what are possible implementations of distributed applications in .net?

0 Answers  

---

What is smart navigation in .net?

0 Answers  

---

syntax for binding the data from database

1 Answers   Satyam,

---

for the textbox if i want to allow only numbers.what ever the characters u enter it should not take.which event u used?

5 Answers   IBM,

---

What are server controls?

1 Answers   Avanade, Wipro,

---

Is .net front end or backend?

0 Answers  

---

Write an StoredProcedure to get the values of a column within a date range.

1 Answers   Deloitte,

---

What are the two kinds of properties.

2 Answers   Wipro,

---