Syntax of Radio Button in VB.Net

Question

0.00/5 (No votes)

See more:

Hi

Friends i am trying the radio information should go in data base but i am not getting it is showing me error

The code which i have writen is

VB

Dim con As New SqlConnection
        Dim cmd As New SqlCommand
        con.ConnectionString = "Data Source=COMP-4\SQLEXPRESS;Initial Catalog=mesco;Integrated Security=True"
        cmd.Connection = con
        cmd.CommandText = "insert into donatetable(donateid,name,age,address,gender,moblieno,email,donationamt)values('"&textname.txt&"','"&txtage.txt&"','"&txtaddress.txt&"','"&RadioButton1.RadioButtonList.&"','"&rbfemale.Select&"','"&&"')"
    End Sub

Can any one help me with the insert code for vb.Net using radio dutton as male and female. and even i am using select @@identity for auto ID generation even this is giving me error plz help
This is my sql query

create table donatetable 
(
name varchar(50),
donorid int,
gender varchar(5),
address varchar(50),
age int,
mobileno int,
email varchar(20),
donationamt int
)

Please help me out with the syntax of radio and it can store in the database
Thanks in advance

Posted 30-Jan-11 17:52pm

aayu

Updated 30-Jan-11 18:18pm

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vishv · Answer 1 · 2011-02-01T18:32:00

here I'm finding two issues in,

One is with "RadioButton1.RadioButtonList." ==> what this . is working there,

rest if you need to get value of the Selected Radio Button List part then rbfemale.Select will not work. you need to write rbFemale.SelectedValue .Also for this if the selected value from RadioButtonList is a string than it's ok to keep it like '"& YourValue &"' but if its an integer than keep it like "& YouValue &". Just check this thing too.

One more thing the number of columns you are trying to insert values is 8 and the values you are providing is 6. This two numbers must be same. This is also the reason.

MArk as answer if it works.

Prerak Patel · Answer 2 · 2011-01-30T21:18:00

Solution 2

Here is the way to get started with RadioButtonList

http://www.java2s.com/Code/ASP/Asp-Control/GetselectedradiobuttonfromradiobuttonlistC.htm[^]

Moreover,
& rbfemale.Select & "','" && "')"
you have an additional & here

Posted 30-Jan-11 21:18pm

Prerak Patel

Abhinav S · Answer 3 · 2011-01-30T17:56:00

Solution 1

RadioButton1.RadioButtonList.&
I see an additional fullstop here. That could be the reason why you are getting an error.

Make sure the value of the radio button to be stored in the table is the same as the table column type.

Posted 30-Jan-11 17:56pm

Abhinav S

Updated 30-Jan-11 17:57pm

v2

Comments

aayu 31-Jan-11 0:03am

can you please help me by writing full insert code plz

Abhinav S 31-Jan-11 1:19am

Just remove the . and try

Syntax of Radio Button in VB.Net

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Syntax of Radio Button in VB.Net

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us