Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


syntax for binding the data from database



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

Please explain what is the difference between encrypting a password and applying a hashing?

0 Answers  


What is the difference between vb.net and vc#.net?

0 Answers  


What is meant by globalization?

0 Answers  


What security mechanisms to enforce for Authenticating and authorizing the users?

1 Answers  


Is .net a language?

0 Answers  


What is assembly in .net?

0 Answers  


what is yield keyword in .Net?

2 Answers  


What is meant by .Net framework?

1 Answers  


Explain the use of ‘this’ keyword in Java?

1 Answers  


Do you know what is lambda expressions in c#?

0 Answers  


What is garbage collection and how it works. Provide a code example of how you can enforce garbage collection in .net?

0 Answers  


Tell us why do we use the “using” statement?

0 Answers  


Categories