asp.net - Pass integer value of radio button to sql server 2008 -

i trying pass value of radio button database. when radio button not checked value 2 pass in no problem. when radiobutton checked value not pass database. error: "input string no in correct format". below code:

dim rbval integer     rbval = convert.toint16(radiobutton1.checked)     rbval = int16.parse(radiobutton1.checked)     if radiobutton1.checked         rbval = 1     else         rbval = 2     end if     cmd.parameters.add(new sqlparameter("@ethics", sqldbtype.int))     cmd.parameters("@ethics").value = rbval 

i sure simple nto seeing it!

your code reads int16.parse(radiobutton1.checked). problem radiobutton1.checked returns boolean value rather integer value, , parse error occurs.

based on code, can delete these lines , things work:

 rbval = convert.toint16(radiobutton1.checked)     rbval = int16.parse(radiobutton1.checked) 

so imagine code like:

dim rbval integer if radiobutton1.checked     rbval = 1 else     rbval = 2 end if cmd.parameters.add(new sqlparameter("@ethics", sqldbtype.int)) cmd.parameters("@ethics").value = rbval