How to insert multiple radio button values at the same time into sql database
How can I insert multiple values from multiple dynamically created radio button list into database using 1 sql query.
For example, I have 3 questions and 4 choices for each and I want to select 1 answer for each.
The problem is the AddHandler will only see the last answer selected and I want also to insert the previous questions answers.
Protected Sub insertbtn(ByVal sender As Object, ByVal e As EventArgs)
Dim cmdcritid As New SqlCommand
Dim cmdqid As New SqlCommand
cmdqid = New SqlCommand("SELECT quest.qid FROM quest WHERE quest.qdesc LIKE '" & Session("rbtext") & "' ", con)
Dim qid As Int16 = cmdqid.ExecuteScalar()
Dim cmdquid As New SqlCommand
cmdquid = New SqlCommand("SELECT quid FROM quiz WHERE quid=" + DropDownList1.SelectedValue, con)
Dim quid As Int16 = cmdquid.ExecuteScalar()
cmdcritid = New SqlCommand("SELECT quest.critid FROM quest WHERE quest.qid= '" & qid & "' ", con)
Dim critid As Int16 = cmdcritid.ExecuteScalar()
Dim cmdpid As New SqlCommand
Dim ins As New SqlCommand
ins = New SqlCommand("INSERT INTO [result](quid,did,critid,qid,pid,qvalue) values('" & quid & "','" & DropDownList3.SelectedValue & "','" & critid & "','" & qid & "','" & DropDownList2.SelectedValue & "','" & Session("qvalue") & "')", con)
ins.ExecuteScalar()
con.Close()
End Sub
