DropDownList Which Binds Values from DB

Question

User-2027411970 posted

Hi All, 

I want to develop a custom asp.net server control. A drop down list which contains values from Database table. 

LIke EmpDropDownList contains Employees Names into Text and ID into Value field. 

How to Develop it?

 

Thanks in Advance. 

Answer 1

User-1814013008 posted

Create one Custom Control which contains properties like ConnectionString, DataValueFiled, DataTextFiled, and TableName.

Bind them in CustomControlLoad event, that will do...

make sure that you are taking care of SelectedValues in post back..

thank you,

-nm reddy

Answer 2

User-1252661541 posted
cmd = new SqlCommand(commandText, conn); cmd.Connection.Open(); dr = cmd.ExecuteReader(); //Bind Priority DropDownList.DataSource = dr; DropDownList.DataTextField = "Name"; DropDownList.DataValueField = "id"; DropDownList.DataBind(); Try This it will work

Answer 3

User-1253086575 posted

 u just need to bind data to dropdown list...

cmd= new sqlcommand("select * from mydatabse",cn)

dropdownlist1.datsource=cmd.executereader

dropdownlist1.datbind();

 

 

Answer 4

User1306565749 posted

Hi

http://msdn.microsoft.com/en-us/library/aa479311.aspx

http://forums.asp.net/t/946824.aspx

Please mark this as Answer, if it helped