select *

i am having this problem.

error msg:

Specified argument was out of the range of valid values

Line 382: RadioButtonList1.SelectedValue = rd.Item("case_type_vc")

!!!!!!!!!??????????????

this is my code

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim cmd As New SqlCommand
        Dim rd As SqlDataReader

        cmd = New SqlCommand("select * from HSR where case_id=@case_id", cn)

        cmd.Parameters.Add("@case_id", TextBox1.Text)

        cn.Open()

        rd = cmd.ExecuteReader

        While rd.Read

            Calendar2.SelectedDate = rd.Item("delivery_dt")
            Calendar1.SelectedDate = rd.Item("HSR_dt")
            CheckBoxList1.SelectedValue = rd.Item("support_type_vc")
            RadioButtonList1.SelectedValue = rd.Item("case_type_vc")
            DropDownList1.SelectedValue = rd.Item("requester_name_vc")
            DropDownList2.SelectedValue = rd.Item("department_vc")
            TextBox2.Text = rd.Item("case_description_vc")
            DropDownList3.SelectedValue = rd.Item("superior_approval_vc")
            TextBox3.Text = rd.Item("analysis_vc")
            CheckBoxList2.SelectedValue = rd.Item("type_vc")
            CheckBoxList3.SelectedValue = rd.Item("subtype_vc")
            CheckBoxList4.SelectedValue = rd.Item("subtype2_vc")
            CheckBoxList5.SelectedValue = rd.Item("subtype3_vc")
            DropDownList4.SelectedValue = rd.Item("IT_name_vc")
            RadioButtonList2.SelectedValue = rd.Item("status_vc")

        End While
        rd.Close()
        cn.Close()

        Button1.Enabled = True
end sub

select *

مواضيع مشابهة