checkboxes in query structure

[bindurajeesh]

I have the following in by web form code behind and it says that "operator
'&' is not defined for types 'String' and
'System.Web.UI.WebControls.checkbox'. How do you pass the value of a
checkbox to a query string? The example below was attempting to use a string
variable 'check' and checked1' for values of the checkboxes but with the
variables in the query I get same error but
'System.Web.UI.WebControls.textbox' instead. This insert query eventually
will take info from several check boxes. Thank you.

strsqlInsert2 = "insert into tblinfo (nameID, intakedate,
static99,SignedContract,DateContractSigned,Probati onViolation," & _
"
ProbationViolationDate,PrematureTermination,Termin ationDate,TerminationReason) values (" & intname & ", '" & txtIntakeDate.Text & _
"', '" & txtStatic99.Text & "', '" & checked & "', '" &
txtDateSigned.Text & "', '" & txtProbationViolation & "', '" &
txtDateOfViolation & _
"', '" & checked1 & "', '" & txtTermDate.Text & "', '" &
txtTermReason.Text & ")"

[Greg Young]

CheckBox.Checked.ToString()

"bindurajeesh" <bi**********@discussions.microsoft.comwrote in message
news:66**********************************@microsof t.com...

>I have the following in by web form code behind and it says that "operator
'&' is not defined for types 'String' and
'System.Web.UI.WebControls.checkbox'. How do you pass the value of a
checkbox to a query string? The example below was attempting to use a
string
variable 'check' and checked1' for values of the checkboxes but with the
variables in the query I get same error but
'System.Web.UI.WebControls.textbox' instead. This insert query eventually
will take info from several check boxes. Thank you.

strsqlInsert2 = "insert into tblinfo (nameID, intakedate,
static99,SignedContract,DateContractSigned,Probati onViolation," & _
"
ProbationViolationDate,PrematureTermination,Termin ationDate,TerminationReason)
values (" & intname & ", '" & txtIntakeDate.Text & _
"', '" & txtStatic99.Text & "', '" & checked & "', '" &
txtDateSigned.Text & "', '" & txtProbationViolation & "', '" &
txtDateOfViolation & _
"', '" & checked1 & "', '" & txtTermDate.Text & "', '" &
txtTermReason.Text & ")"

[bindurajeesh]

Thanks that did it.

"Greg Young" wrote:

CheckBox.Checked.ToString()

"bindurajeesh" <bi**********@discussions.microsoft.comwrote in message
news:66**********************************@microsof t.com...

I have the following in by web form code behind and it says that "operator
'&' is not defined for types 'String' and
'System.Web.UI.WebControls.checkbox'. How do you pass the value of a
checkbox to a query string? The example below was attempting to use a
string
variable 'check' and checked1' for values of the checkboxes but with the
variables in the query I get same error but
'System.Web.UI.WebControls.textbox' instead. This insert query eventually
will take info from several check boxes. Thank you.

strsqlInsert2 = "insert into tblinfo (nameID, intakedate,
static99,SignedContract,DateContractSigned,Probati onViolation," & _
"
ProbationViolationDate,PrematureTermination,Termin ationDate,TerminationReason)
values (" & intname & ", '" & txtIntakeDate.Text & _
"', '" & txtStatic99.Text & "', '" & checked & "', '" &
txtDateSigned.Text & "', '" & txtProbationViolation & "', '" &
txtDateOfViolation & _
"', '" & checked1 & "', '" & txtTermDate.Text & "', '" &
txtTermReason.Text & ")"