Reading Radio Button Values into the database

[kitskaps]

I have used 4 radiobuttons nd not radiobutton list.what ia m atrying to do is i want to store the text value of the buttong in DB. But in the insert query i am not gettin the method to select its value..........i.e if i take ' " + radiobutton1.text + " ' then how would i select the other button value......................
I have written a code that is working for itbut i am not satisfied with it if there could be any other method for it............i would really appreciate.....
UI am writing down my code:

CODE----
Dim cls As New dbconnection
Dim s As String = "Upgrade"

Dim q As String = "Software"
--------------------------------------------------------------------------------------------------------------------
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Dim Textarea As String
'Textarea = Textarea1.Value
cls.dbconnection(True)
cls.ExecuteQuery("INSERT INTO Troubleshooting(StartDate,Type,InTermsof,Priority, Description,ProposedUsage,ApproximateCost,Status,T ypeOfRequest)
Values ('" + CDate(TextBox1.Text.ToString) + "','" & s & " ','" & q & " ', '" + DropDownList1.SelectedValue.ToString + "','" + TextBox4.Text + "','" + TextBox5.Text + " ',' " & TextBox3.Text.Trim & " ','Not Started','Configuration')")

cls.dbconnection(False)
Response.Redirect("Successmsg.aspx", True)
End Sub
--------------------------------------------------------------------------------------------------------------------
Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged


If RadioButton1.Checked = True Then
RadioButton1.Text = "New"
s = RadioButton1.Text.ToString
Else
s = ""
End If
End Sub
--------------------------------------------------------------------------------------------------------------------
Private Sub RadioButton3_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton3.CheckedChanged
If RadioButton3.Checked = True Then
RadioButton3.Text = "Hardware"
q = RadioButton3.Text.ToString
Else
q = ""

End If
End Sub

what to do plz guide me down.....................urgent
Thanks in advance

[gomzi]

I have used 4 radiobuttons nd not radiobutton list.what ia m atrying to do is i want to store the text value of the buttong in DB. But in the insert query i am not gettin the method to select its value..........i.e if i take ' " + radiobutton1.text + " ' then how would i select the other button value......................
I have written a code that is working for itbut i am not satisfied with it if there could be any other method for it............i would really appreciate.....
UI am writing down my code:

CODE----
Dim cls As New dbconnection
Dim s As String = "Upgrade"

Dim q As String = "Software"
--------------------------------------------------------------------------------------------------------------------
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Dim Textarea As String
'Textarea = Textarea1.Value
cls.dbconnection(True)
cls.ExecuteQuery("INSERT INTO Troubleshooting(StartDate,Type,InTermsof,Priority, Description,ProposedUsage,ApproximateCost,Status,T ypeOfRequest)
Values ('" + CDate(TextBox1.Text.ToString) + "','" & s & " ','" & q & " ', '" + DropDownList1.SelectedValue.ToString + "','" + TextBox4.Text + "','" + TextBox5.Text + " ',' " & TextBox3.Text.Trim & " ','Not Started','Configuration')")

cls.dbconnection(False)
Response.Redirect("Successmsg.aspx", True)
End Sub
--------------------------------------------------------------------------------------------------------------------
Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged


If RadioButton1.Checked = True Then
RadioButton1.Text = "New"
s = RadioButton1.Text.ToString
Else
s = ""
End If
End Sub
--------------------------------------------------------------------------------------------------------------------
Private Sub RadioButton3_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton3.CheckedChanged
If RadioButton3.Checked = True Then
RadioButton3.Text = "Hardware"
q = RadioButton3.Text.ToString
Else
q = ""

End If
End Sub

what to do plz guide me down.....................urgent
Thanks in advance

my hunch is that you will be better off with a radiobuttonlist.

Its great that you have posted the code, but it will be easier to understand your problem if you try and explain a bit more.