[melodimoeti]

Hi,
i have a form in vb.net and it has two groups of radio buttons and once a selection is made i need to update it and save it into the database(ms access). i am failing to get the information to save into the access database but instead i am getting an error on the command execute query. here is my code:
[code]
strSQL = "INSERT INTO development VALUES (" & Label2.Text & "','" & Label3.Text & "','" & Label4.Text & "','" & Label5.Text & "','" & Label6.Text & "','" & Label20.Text & "','" & Label21.Text & "','" & RadioButton5.Text & "','" & RadioButton6.Text & "'," & devstaffid.Text & ",'" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox5.Text & "','" & dateindev.Text & ")"
oledbcon.Open()
Dim cmd As New OleDbCommand(strSQL, oledbcon)
cmd.ExecuteNonQuery()
MsgBox("Development Info Saved Successfully !", MsgBoxStyle.Information, "Records Management System")
oledbcon.Close()
[\code]

the error is on this line:
[code]cmd.ExecuteNonQuery()
[\code]

[noorahmad]

use this code

RadioButton5.Value

[DataPriest]

The RadioButton control returns a boolean value, which means True or False without the single quotes. Therefore your code should read:

strSQL = "INSERT INTO development VALUES (" & Label2.Text & "','" & Label3.Text & "','" & Label4.Text & "','" & Label5.Text & "','" & Label6.Text & "','" & Label20.Text & "','" & Label21.Text & "'," & RadioButton5.Value & "," & RadioButton6.Value & "," & devstaffid.Text & ",'" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox5.Text & "','" & dateindev.Text & "')"
oledbcon.Open()
Dim cmd As New OleDbCommand(strSQL, oledbcon)
cmd.ExecuteNonQuery()
MsgBox("Development Info Saved Successfully !", MsgBoxStyle.Information, "Records Management System")
oledbcon.Close()

Please note there is a single quote just before the last closed parenthesis. You forgot to put one.

[melodimoeti]

DataPriest, on 4 May, 2009 - 12:37 PM, said:

The RadioButton control returns a boolean value, which means True or False without the single quotes. Therefore your code should read:

strSQL = "INSERT INTO development VALUES (" & Label2.Text & "','" & Label3.Text & "','" & Label4.Text & "','" & Label5.Text & "','" & Label6.Text & "','" & Label20.Text & "','" & Label21.Text & "'," & RadioButton5.Value & "," & RadioButton6.Value & "," & devstaffid.Text & ",'" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox5.Text & "','" & dateindev.Text & "')"
oledbcon.Open()
Dim cmd As New OleDbCommand(strSQL, oledbcon)
cmd.ExecuteNonQuery()
MsgBox("Development Info Saved Successfully !", MsgBoxStyle.Information, "Records Management System")
oledbcon.Close()

Please note there is a single quote just before the last closed parenthesis. You forgot to put one.

when i write radiobutton5.value gives error saying 'value' is not a member of 'System.windows.forms.radiobutton'

[firebolt]

by the way, its the other slash to end the code. / not \

[melodimoeti]

firebolt, on 5 May, 2009 - 07:26 AM, said:

by the way, its the other slash to end the code. / not \

thanks for the correction

[sakhr_99]

The best way is to save a value into variable and then store the value as is in the insert statement here is an example


Dim rbtnValue as string
If RadioButton.checked then
rbtnValue = RadioButton.Value
else
'''

end if



then
"Insert into Table values ('" & rbtnValue&"') "



-------------

This could solve your problem

[melodimoeti]

sakhr_99, on 5 May, 2009 - 09:27 AM, said:

The best way is to save a value into variable and then store the value as is in the insert statement here is an example


Dim rbtnValue as string
If RadioButton.checked then
rbtnValue = RadioButton.Value
else
'''

end if



then
"Insert into Table values ('" & rbtnValue&"') "



-------------

This could solve your problem

hi i tried RadioButton.Value and it still gives the same error, it does not recognise .Value for radio button

[k4k45h1]

melodimoeti, on 5 May, 2009 - 11:05 AM, said:

sakhr_99, on 5 May, 2009 - 09:27 AM, said:

The best way is to save a value into variable and then store the value as is in the insert statement here is an example


Dim rbtnValue as string
If RadioButton.checked then
rbtnValue = RadioButton.Value
else
'''

end if



then
"Insert into Table values ('" & rbtnValue&"') "



-------------

This could solve your problem

hi i tried RadioButton.Value and it still gives the same error, it does not recognise .Value for radio button

i'm having the same problem... anyone have other suggestion? thanks

This post has been edited by k4k45h1: 21 June 2009 - 09:20 PM

[sakhr_99]

you can also use

RadioButton.Text
to store text that appear in RadioButton

ex : if you want to Store Male as text in DB
and you have radio Button called Male right next beside it as Text property
user
rbtn.Text

to store the value

[eworm]

Yeah, you're still trying to use .Value which isn't a property for a RadioButton. You want to use .Checked.

Dim strRadioText as String

If RadioButton1.Checked = True Then
	 strRadioText = RadioButton1.Text
Elseif RadioButton2.Checked = True Then
	 strRadioText = RadioButton2.Text
Else
	 strRadioText = RadioButton3.Text
End If

Then in your SQL Insert Statement change your RadioButton.Values to the variables that correspond with them.

Hope this helps...

This post has been edited by eworm: 24 June 2009 - 11:37 AM