Hey Guys.

I'm really having trouble here getting the results of a radiolist into my database.

The Sql statement works fine so the problem lies with either my parameters or with the radio list itself but I really can't get my head around this.

My parameter is;

Dim paramQ1 as New OleDBParameter
paramQ1.ParameterName = "@Q1"
paramQ1.Value = Q1.selecteditem.value
paramQ1.DbType = DbType.

The DbType is blank because I have no idea what goes here and have been trying everything I can think of without results.

My radiolist is;

<asp:RadioButtonList ID="Q1" runat="server">
<asp:ListItem Value="1" Text="Excellent"></asp:ListItem>
<asp:ListItem Value="2" Text="Good"></asp:ListItem>
<asp:ListItem Value="3" Text="Adequate" Selected="true"></asp:ListItem>
<asp:ListItem Value="4" Text="Less than adequate"></asp:ListItem>
<asp:ListItem Value="5" Text="Poor"></asp:ListItem>

I've got the submit button working a couple of times now so that it doesn't pass an error but its inserting "0" into my database rather than the listitem values.

Any suggestions? My aim is to choose a value in my radio list, take the corresponding value i.e. 1 for excellent, and to submit this into my database.

Thanks in advance