M
msn
I am trying to update my database with the code below, but I have a problem
it neither buton is selected???
<asp:radiobuttonlist id="BDec1" runat="server" RepeatDirection="Horizontal"
ForeColor="#1e60a2">
<asp:ListItem Value="y"></asp:ListItem>
<asp:ListItem Value="n"></asp:ListItem>
</asp:radiobuttonlist></td>
ContactInfoUpdate.UpdatePage11(userId, BDec1.SelectedItem.Value,........)
Public Function UpdatePage11(ByVal userId As Integer, ByVal BDec1 As String,
.............)
' Create Instance of Connection and Command Object
Dim myConnection As New
SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
Dim myCommand As New SqlCommand("UpdatePage11", myConnection)
' Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure
Dim parameteruserId As New SqlParameter("@userId", SqlDbType.Int)
parameteruserId.Value = userId
myCommand.Parameters.Add(parameteruserId)
Dim parameterBDec1 As New SqlParameter("@BDec1", SqlDbType.Int)
parameterBDec1.Value = BDec1
myCommand.Parameters.Add(parameterBDec1)
it neither buton is selected???
<asp:radiobuttonlist id="BDec1" runat="server" RepeatDirection="Horizontal"
ForeColor="#1e60a2">
<asp:ListItem Value="y"></asp:ListItem>
<asp:ListItem Value="n"></asp:ListItem>
</asp:radiobuttonlist></td>
ContactInfoUpdate.UpdatePage11(userId, BDec1.SelectedItem.Value,........)
Public Function UpdatePage11(ByVal userId As Integer, ByVal BDec1 As String,
.............)
' Create Instance of Connection and Command Object
Dim myConnection As New
SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
Dim myCommand As New SqlCommand("UpdatePage11", myConnection)
' Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure
Dim parameteruserId As New SqlParameter("@userId", SqlDbType.Int)
parameteruserId.Value = userId
myCommand.Parameters.Add(parameteruserId)
Dim parameterBDec1 As New SqlParameter("@BDec1", SqlDbType.Int)
parameterBDec1.Value = BDec1
myCommand.Parameters.Add(parameterBDec1)