asp:checkbox insert a "1" or "0" for true or false HELP!

[bkedersha]

I need to have an asp:checkbox place a "1", when it is checked, in a field in my sql server database or place a "0" when it is not checked.

I started with this:

Sub DoQuarterlyOverWrite(sender As Object, e As EventArgs)

If Quaterly.Checked=true Then
Quarterly.checked = "1"
Else
Quarterly.Checked = "0"
End If

End Sub

I need to use this SQL insert because that is what the older developer used for this page.

dim Cmd as new SQLCommand("InsertNewGrant",conn)

cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@GrantNumber", GrantNumber.Text.Trim())
cmd.Parameters.Add("@GrantProjectName", ProjectName.Text.Trim())
cmd.Parameters.Add("@CountryId", Country.SelectedItem.Value)
cmd.Parameters.Add("@Description", 0)
cmd.Parameters.Add("@CreateUserId", lblLoggedInAsId.text.Trim())
cmd.Parameters.Add("@UpdateUserId", 0)
cmd.Parameters.Add("@ObligationDate", ObligationDate.SelectedDate)
cmd.Parameters.Add("@OrigionalExpDate", CurrentExpirationDate.SelectedDate)
cmd.Parameters.Add("@CurrentExpDate", CurrentExpirationDate.SelectedDate)
cmd.Parameters.Add("@Terminated", 0)
cmd.Parameters.Add("@Suspended", 0)
cmd.Parameters.Add("@Locked", 0)
cmd.Parameters.Add("@LockedByUserId", 0)
cmd.Parameters.Add("@ACTNumber", 0)
cmd.Parameters.Add("@GranteeName", GranteeName.Text.Trim())
cmd.Parameters.Add("@GranteeAddress1", AddressLine1.Text.Trim())
cmd.Parameters.Add("@GranteeAddress2", AddressLine2.Text.Trim())
cmd.Parameters.Add("@GranteeAddress3", AddressLine3.Text.Trim())
Cmd.connection.open()
Cmd.ExecuteNonQuery()
Cmd.connection.close()


Help!

 

[kahlua001]

the Stored Procedure needs to be modified so it takes int a @Quarterly parameter and the insert statment needs to insert this value. Then you need to add this paramter into your command object. Also, your if statment should look something like this..

If Quartherly.Checked Then
cmd.Parameters.Add("@Quarterly", 1)
Else
cmd.Parameters.Add("@Quarterly", 0)
Enf If

 

[bri189a]

Or you could:

cmd.Parameters.Add("@Quarterly", Convert.ToInt(Quarterly.Checked))