| Author: D.Jeya kumar(JK) 29 Aug 2008 | Member Level: Diamond | Rating: Points: 5 |
Hi,
Use the Dataset.Tables(0) to bind the Dataset to the Drowdown and then you need to set the column name as DropDownList1.DataTextField and DropDownList1.DataValueField just like the below code.
DropDownList1.DataSource = ds.Tables(0) 'It will show the Values in the dropdown DropDownList1.DataTextField = "Columnname" 'It will not be shown as it is used for internal purpose DropDownList1.DataValueField = "Columnname"
Regards JK
|