A
Ankit Aneja
code of my aspx page
<asp:RadioButtonList id="RadioButtonList1"
runat="server"></asp:RadioButtonList>
now i want to bind data from database
Dim rsComm As SqlCommand
Dim rsReader As SqlDataReader
Dim strSql As String
Dim con As SqlConnection
con = New SqlConnection("server=abc;UID=sa;PWD=sa;initial
catalog=digicertify")
con.Open()
strSql = "select certName from certDetail"
rsComm = New SqlCommand(strSql, con)
rsReader = rsComm.ExecuteReader
rsReader = rsReader
RadioButtonList1.DataSource = rsReader
RadioButtonList1.DataBind()
rsReader.Close()
rsComm.Dispose()
con.Close()
it makes radio buttons as no. of items selected but instead of displaying
certName as selected in query it displays
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
in front of each radio button
<asp:RadioButtonList id="RadioButtonList1"
runat="server"></asp:RadioButtonList>
now i want to bind data from database
Dim rsComm As SqlCommand
Dim rsReader As SqlDataReader
Dim strSql As String
Dim con As SqlConnection
con = New SqlConnection("server=abc;UID=sa;PWD=sa;initial
catalog=digicertify")
con.Open()
strSql = "select certName from certDetail"
rsComm = New SqlCommand(strSql, con)
rsReader = rsComm.ExecuteReader
rsReader = rsReader
RadioButtonList1.DataSource = rsReader
RadioButtonList1.DataBind()
rsReader.Close()
rsComm.Dispose()
con.Close()
it makes radio buttons as no. of items selected but instead of displaying
certName as selected in query it displays
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
System.Data.Common.DbDataRecord
in front of each radio button