Issues in generating radiobuttonlist from MSSQL..

[Guest]

i wanted to generate a radiobuttonlist, that lists items from MSSQL query.

Like the table had

DPRT_ID DPRT_NAME
1 HR
2 IT
3 ADMIN

Here the vb code…

Dim conPubs As SqlConnection
Dim cmdSelect As SqlCommand
Dim mydata As DataSet
conPubs = New SqlConnection("server=XXX;Database=XXX;uid=sa;password=;")
cmdSelect = New SqlCommand("select * from tbl_Departments", conPubs)

conPubs.Open()
radiobuttonlist1.DataSource = cmdSelect.ExecuteReader()
radiobuttonlist1.DataBind()
conPubs.Close()

when I run this I don’t see anything in my aspx page..

help me…

 

[Christopher Reed]

Before the radiobuttonlist1.DataBind(), add these lines:

radiobuttonlist1.DataTextField = "DPRT_NAME"
radiobuttonlist1.DataValueField = "DPRT_ID"

 

[Guest]

thx it worked...

Before the radiobuttonlist1.DataBind(), add these lines:

radiobuttonlist1.DataTextField = "DPRT_NAME"
radiobuttonlist1.DataValueField = "DPRT_ID"