Issues in generating radiobuttonlist from MSSQL.. -- dotnet framework

velu
2/21/2006 6:37:27 PM

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..

velu
2/21/2006 10:23:27 PM

thx it worked...

[quoted text, click to view]

Christopher Reed
2/21/2006 11:19:06 PM

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

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

--
Christopher A. Reed
"The oxen are slow, but the earth is patient."

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet framework

dotnet framework : Issues in generating radiobuttonlist from MSSQL..