How to bring a database record to DropdownList in asp .net app?

[Praveen 123]

Hi, I am doing a asp.net app.My backend is MS-Access.Plaes send me the code to bring a access data base record to the DropdownList. Eg:To list all employee_names in a table to DropownList.

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[krishnakumark]

Hi Praveen if you are using .net 2.0, You either use datareader and attach that with the dropdownlist (.net 1.1 and .net 2.0) OR create a acces datasource and attach it with the dropdown list... Krishna Kumar

Kk

[Praveen 123]

Sir that attaching code i am asking,My data base is attached to the page using oledb connection.Now on loading the page i want to display the data base records on the DropdownList

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[krishnakumark]

Hi ..Try this..dont forget to include System.Data.OleDb namespace OleDbConnection con= new OleDbConnection("Place your connection string here"); string sql="select id,name from users"; OleDbCommand sqlcmd = new OleDbCommand(sql,con); con.Open(); DropDownList1.DataSource= sqlcmd.ExecuteReader(CommandBehavior.CloseConnection); DropDownList1.DataTextField = "name"; DropDownList1.DataValueField = "id"; DropDownList1.DataBind();

Kk

[Praveen 123]

sir, What the "name" and "id" reprecents....Because both are bringing to the same dropdown list..

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[krishnakumark]

Name is the test .. which will be displayed in the dropdown .. and id is the value which will be stroed internally...

Kk

[krishnakumark]

sorry for the mistake... Name is the text (and not test) .. which will be displayed in the dropdown .. and id is the value which will be stroed internally...

Kk