Check box

[JJ297]

Hello can someone assist me...
I've added two check boxes to my page
<asp:CheckBox ID="ChkYes" runat="server" Text="Yes" /><br />
<asp:CheckBox ID="ChkNo" runat="server" Text="No" /

I have a stored procedure set up to enter in the Yes or No answer.
How do I set that up on the code behind page?

This is what I have thus far, all of the other data on the page is
going into the database now I just need to add the check box value.

The two fields in the Database are called DisplayedQues and
NonDisplayedQue s

Dim question As String = TxtQuestion.Tex t
Dim answer As String = TxtAnswer.Text
Dim conn As New Data.SqlClient. SqlConnection(" Data
Source=seb2a54; Initial Catalog=EDCSFAQ S;Persist Security
Info=True;User ID=EDCSFAQUser; Password=fax")

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
..Connection = conn 'the connection
..CommandType = Data.CommandTyp e.StoredProcedu re
..CommandText = "EnterAdminQues tion"
..Parameters.Ad dWithValue("@to picid",
CInt(DropDownLi st1.SelectedIte m.Value))
..Parameters.Ad dWithValue("@qu esdate", QuesDate.Text)
..Parameters.Ad dWithValue("@qu estions", TxtQuestion.Tex t)
..Parameters.Ad dWithValue("@An swer", TxtAnswer.Text)
..Parameters.Ad dWithValue("@Di splayedQues", what do I put here???)
..Parameters.Ad dWithValue("@No nDisplayedQues" , what do I put here???)

Thanks so much.

[Cowboy \(Gregory A. Beamer\)]

Dim displayedQues as Boolean = False
Dim nonDisplayedQue s as Boolean = False

If (ChkYes.Checked ) Then
displayedQues = True
End If

If (ChkNo.Checked) Then
nonDisplayedQue s = True
End If
Dim cmd As New Data.SqlClient. SqlCommand
With cmd
..Connection = conn 'the connection
..CommandType = Data.CommandTyp e.StoredProcedu re
..CommandText = "EnterAdminQues tion"
..Parameters.Ad dWithValue("@to picid",
CInt(DropDownLi st1.SelectedIte m.Value))
..Parameters.Ad dWithValue("@qu esdate", QuesDate.Text)
..Parameters.Ad dWithValue("@qu estions", TxtQuestion.Tex t)
..Parameters.Ad dWithValue("@An swer", TxtAnswer.Text)
..Parameters.Ad dWithValue("@Di splayedQues", displayedQues)
..Parameters.Ad dWithValue("@No nDisplayedQues" , nonDisplayedQue s)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

*************** *************** *************** ***
Think outside the box!
*************** *************** *************** ***
"JJ297" <nc***@yahoo.co mwrote in message
news:11******** ************@q7 5g2000hsh.googl egroups.com...

Hello can someone assist me...
I've added two check boxes to my page
<asp:CheckBox ID="ChkYes" runat="server" Text="Yes" /><br />
<asp:CheckBox ID="ChkNo" runat="server" Text="No" /

I have a stored procedure set up to enter in the Yes or No answer.
How do I set that up on the code behind page?

This is what I have thus far, all of the other data on the page is
going into the database now I just need to add the check box value.

The two fields in the Database are called DisplayedQues and
NonDisplayedQue s

Dim question As String = TxtQuestion.Tex t
Dim answer As String = TxtAnswer.Text
Dim conn As New Data.SqlClient. SqlConnection(" Data
Source=seb2a54; Initial Catalog=EDCSFAQ S;Persist Security
Info=True;User ID=EDCSFAQUser; Password=fax")

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Add WithValue("@top icid",
CInt(DropDownLi st1.SelectedIte m.Value))
.Parameters.Add WithValue("@que sdate", QuesDate.Text)
.Parameters.Add WithValue("@que stions", TxtQuestion.Tex t)
.Parameters.Add WithValue("@Ans wer", TxtAnswer.Text)
.Parameters.Add WithValue("@Dis playedQues", what do I put here???)
.Parameters.Add WithValue("@Non DisplayedQues", what do I put here???)

Thanks so much.

[JJ297]

On Jul 27, 12:34 pm, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbwo... @comcast.netNoS pamMwrote:

Dim displayedQues as Boolean = False
Dim nonDisplayedQue s as Boolean = False

If (ChkYes.Checked ) Then
displayedQues = True
End If

If (ChkNo.Checked) Then
nonDisplayedQue s = True
End If

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Add WithValue("@top icid",
CInt(DropDownLi st1.SelectedIte m.Value))
.Parameters.Add WithValue("@que sdate", QuesDate.Text)
.Parameters.Add WithValue("@que stions", TxtQuestion.Tex t)
.Parameters.Add WithValue("@Ans wer", TxtAnswer.Text)
.Parameters.Add WithValue("@Dis playedQues", displayedQues)
.Parameters.Add WithValue("@Non DisplayedQues", nonDisplayedQue s)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBAhttp://gregorybeamer.s paces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

*************** *************** *************** ***
Think outside the box!
*************** *************** *************** ***"JJ297" <[e-mail] mwrote in message

news:11******** ************@q7 5g2000hsh.googl egroups.com...

Hello can someone assist me...

I've added two check boxes to my page

<asp:CheckBox ID="ChkYes" runat="server" Text="Yes" /><br />
<asp:CheckBox ID="ChkNo" runat="server" Text="No" /

I have a stored procedure set up to enter in the Yes or No answer.
How do I set that up on the code behind page?

This is what I have thus far, all of the other data on the page is
going into the database now I just need to add the check box value.

The two fields in the Database are called DisplayedQues and
NonDisplayedQue s

Dim question As String = TxtQuestion.Tex t
Dim answer As String = TxtAnswer.Text

Dim conn As New Data.SqlClient. SqlConnection(" Data
Source=seb2a54; Initial Catalog=EDCSFAQ S;Persist Security
Info=True;User ID=EDCSFAQUser; Password=fax")

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Add WithValue("@top icid",
CInt(DropDownLi st1.SelectedIte m.Value))
.Parameters.Add WithValue("@que sdate", QuesDate.Text)
.Parameters.Add WithValue("@que stions", TxtQuestion.Tex t)
.Parameters.Add WithValue("@Ans wer", TxtAnswer.Text)
.Parameters.Add WithValue("@Dis playedQues", what do I put here???)
.Parameters.Add WithValue("@Non DisplayedQues", what do I put here???)

Thanks so much.- Hide quoted text -

- Show quoted text -

Thanks for assisting me I'm all set but have another question...

I have a field in this same database called CDPPin. I'm using a
session variable to get the pin. How do I call it? Do I...

Dim Session (CDPUser)

Then call it like this?

.Parameters.Add WithValue("@Dis playedQues", displayedQues)
.Parameters.Add WithValue("@Non DisplayedQues", nonDisplayedQue s)

.. Parameters.AddW ithValue("@CDPP in", CDPPin)?

[Lit]

Dim CDPPin as Integer
CDPPin = CType(Session(" CDPUser"), Integer)

pass CDPPin to Stored procedure.
"JJ297" <nc***@yahoo.co mwrote in message
news:11******** *************@l 70g2000hse.goog legroups.com...

On Jul 27, 12:34 pm, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbwo... @comcast.netNoS pamMwrote:

>Dim displayedQues as Boolean = False
Dim nonDisplayedQue s as Boolean = False

If (ChkYes.Checked ) Then
displayedQues = True
End If

If (ChkNo.Checked) Then
nonDisplayedQue s = True
End If

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Ad dWithValue("@to picid",
CInt(DropDownL ist1.SelectedIt em.Value))
.Parameters.Ad dWithValue("@qu esdate", QuesDate.Text)
.Parameters.Ad dWithValue("@qu estions", TxtQuestion.Tex t)
.Parameters.Ad dWithValue("@An swer", TxtAnswer.Text)
.Parameters.Ad dWithValue("@Di splayedQues", displayedQues)
.Parameters.Ad dWithValue("@No nDisplayedQues" , nonDisplayedQue s)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBAhttp://gregorybeamer.s paces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

************** *************** *************** ****
Think outside the box!
************** *************** *************** ****"JJ297" <[e-mail] m>
wrote in message

news:11******* *************@q 75g2000hsh.goog legroups.com...

Hello can someone assist me...

I've added two check boxes to my page

<asp:CheckBox ID="ChkYes" runat="server" Text="Yes" /><br />
<asp:CheckBox ID="ChkNo" runat="server" Text="No" /

I have a stored procedure set up to enter in the Yes or No answer.
How do I set that up on the code behind page?

This is what I have thus far, all of the other data on the page is
going into the database now I just need to add the check box value.

The two fields in the Database are called DisplayedQues and
NonDisplayedQue s

Dim question As String = TxtQuestion.Tex t
Dim answer As String = TxtAnswer.Text

Dim conn As New Data.SqlClient. SqlConnection(" Data
Source=seb2a54; Initial Catalog=EDCSFAQ S;Persist Security
Info=True;User ID=EDCSFAQUser; Password=fax")

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Add WithValue("@top icid",
CInt(DropDownLi st1.SelectedIte m.Value))
.Parameters.Add WithValue("@que sdate", QuesDate.Text)
.Parameters.Add WithValue("@que stions", TxtQuestion.Tex t)
.Parameters.Add WithValue("@Ans wer", TxtAnswer.Text)
.Parameters.Add WithValue("@Dis playedQues", what do I put here???)
.Parameters.Add WithValue("@Non DisplayedQues", what do I put here???)

Thanks so much.- Hide quoted text -

- Show quoted text -

Thanks for assisting me I'm all set but have another question...

I have a field in this same database called CDPPin. I'm using a
session variable to get the pin. How do I call it? Do I...

Dim Session (CDPUser)

Then call it like this?

>.Parameters.Ad dWithValue("@Di splayedQues", displayedQues)
.Parameters.Ad dWithValue("@No nDisplayedQues" , nonDisplayedQue s)

. Parameters.AddW ithValue("@CDPP in", CDPPin)?

[Cowboy \(Gregory A. Beamer\)]

Assuming it is an Integer. If not, you will have to change to the correct
type, but Lit is right on track with the solution.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

*************** *************** *************** ***
Think outside the box!
*************** *************** *************** ***
"Lit" <sq**********@h otmail.comwrote in message
news:uZ******** ******@TK2MSFTN GP03.phx.gbl...

Dim CDPPin as Integer
CDPPin = CType(Session(" CDPUser"), Integer)

pass CDPPin to Stored procedure.
"JJ297" <nc***@yahoo.co mwrote in message
news:11******** *************@l 70g2000hse.goog legroups.com...

>On Jul 27, 12:34 pm, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbwo.. [e-mail] SpamMwrote:

>>Dim displayedQues as Boolean = False
Dim nonDisplayedQue s as Boolean = False

If (ChkYes.Checked ) Then
displayedQues = True
End If

If (ChkNo.Checked) Then
nonDisplayedQue s = True
End If

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandTyp e = Data.CommandTyp e.StoredProcedu re
.CommandTex t = "EnterAdminQues tion"
.Parameters.A ddWithValue("@t opicid",
CInt(DropDown List1.SelectedI tem.Value))
.Parameters.A ddWithValue("@q uesdate", QuesDate.Text)
.Parameters.A ddWithValue("@q uestions", TxtQuestion.Tex t)
.Parameters.A ddWithValue("@A nswer", TxtAnswer.Text)
.Parameters.A ddWithValue("@D isplayedQues", displayedQues)
.Parameters.A ddWithValue("@N onDisplayedQues ", nonDisplayedQue s)

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBAhttp://gregorybeamer.s paces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

************* *************** *************** *****
Think outside the box!
************* *************** *************** *****"JJ297"
<nc...@yahoo. comwrote in message

news:11****** **************@ q75g2000hsh.goo glegroups.com.. .

Hello can someone assist me...

I've added two check boxes to my page

<asp:CheckBo x ID="ChkYes" runat="server" Text="Yes" /><br />
<asp:CheckBo x ID="ChkNo" runat="server" Text="No" /

I have a stored procedure set up to enter in the Yes or No answer.
How do I set that up on the code behind page?

This is what I have thus far, all of the other data on the page is
going into the database now I just need to add the check box value.

The two fields in the Database are called DisplayedQues and
NonDisplayedQu es

Dim question As String = TxtQuestion.Tex t
Dim answer As String = TxtAnswer.Text

Dim conn As New Data.SqlClient. SqlConnection(" Data
Source=seb2a54 ;Initial Catalog=EDCSFAQ S;Persist Security
Info=True;Us er ID=EDCSFAQUser; Password=fax")

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Ad dWithValue("@to picid",
CInt(DropDownL ist1.SelectedIt em.Value))
.Parameters.Ad dWithValue("@qu esdate", QuesDate.Text)
.Parameters.Ad dWithValue("@qu estions", TxtQuestion.Tex t)
.Parameters.Ad dWithValue("@An swer", TxtAnswer.Text)
.Parameters.Ad dWithValue("@Di splayedQues", what do I put here???)
.Parameters.Ad dWithValue("@No nDisplayedQues" , what do I put here???)

Thanks so much.- Hide quoted text -

- Show quoted text -

Thanks for assisting me I'm all set but have another question...

I have a field in this same database called CDPPin. I'm using a
session variable to get the pin. How do I call it? Do I...

Dim Session (CDPUser)

Then call it like this?

>>.Parameters.A ddWithValue("@D isplayedQues", displayedQues)
.Parameters.A ddWithValue("@N onDisplayedQues ", nonDisplayedQue s)

. Parameters.AddW ithValue("@CDPP in", CDPPin)?

[JJ297]

On Jul 27, 5:51 pm, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbwo... @comcast.netNoS pamMwrote:

Assuming it is an Integer. If not, you will have to change to the correct
type, but Lit is right on track with the solution.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBAhttp://gregorybeamer.s paces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

*************** *************** *************** ***
Think outside thebox!
*************** *************** *************** ***"Lit" <sql_agent...@h otmail.comwrote in message

news:uZ******** ******@TK2MSFTN GP03.phx.gbl...

Dim CDPPin as Integer
CDPPin = CType(Session(" CDPUser"), Integer)

pass CDPPin to Stored procedure.

"JJ297" <[e-mail] mwrote in message
news:11******** *************@l 70g2000hse.goog legroups.com...

On Jul 27, 12:34 pm, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbwo... @comcast.netNoS pamMwrote:
Dim displayedQues as Boolean = False
Dim nonDisplayedQue s as Boolean = False

>If (ChkYes.Checked ) Then
displayedQues = True
End If

>If (ChkNo.Checked) Then
nonDisplayedQue s = True
End If

>Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Ad dWithValue("@to picid",
CInt(DropDownL ist1.SelectedIt em.Value))
.Parameters.Ad dWithValue("@qu esdate", QuesDate.Text)
.Parameters.Ad dWithValue("@qu estions", TxtQuestion.Tex t)
.Parameters.Ad dWithValue("@An swer", TxtAnswer.Text)
.Parameters.Ad dWithValue("@Di splayedQues", displayedQues)
.Parameters.Ad dWithValue("@No nDisplayedQues" , nonDisplayedQue s)

>--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBAhttp://gregorybeamer.s paces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

>************** *************** *************** ****
Think outside thebox!
************** *************** *************** ****"JJ297"
<nc...@yahoo.c omwrote in message

>>news:11****** **************@ q75g2000hsh.goo glegroups.com.. .

Hello can someone assist me...

I've added twocheckboxes to my page

<asp:CheckBox ID="ChkYes" runat="server" Text="Yes" /><br />
<asp:CheckBox ID="ChkNo" runat="server" Text="No" /

I have a stored procedure set up to enter in the Yes or No answer.
How do I set that up on the code behind page?

This is what I have thus far, all of the other data on the page is
going into the database now I just need to add thecheckboxvalu e.

The two fields in the Database are called DisplayedQues and
NonDisplayedQue s

Dim question As String = TxtQuestion.Tex t
Dim answer As String = TxtAnswer.Text

Dim conn As New Data.SqlClient. SqlConnection(" Data
Source=seb2a54; Initial Catalog=EDCSFAQ S;Persist Security
Info=True;User ID=EDCSFAQUser; Password=fax")

Dim cmd As New Data.SqlClient. SqlCommand
With cmd
.Connection = conn 'the connection
.CommandType = Data.CommandTyp e.StoredProcedu re
.CommandText = "EnterAdminQues tion"
.Parameters.Add WithValue("@top icid",
CInt(DropDownLi st1.SelectedIte m.Value))
.Parameters.Add WithValue("@que sdate", QuesDate.Text)
.Parameters.Add WithValue("@que stions", TxtQuestion.Tex t)
.Parameters.Add WithValue("@Ans wer", TxtAnswer.Text)
.Parameters.Add WithValue("@Dis playedQues", what do I put here???)
.Parameters.Add WithValue("@Non DisplayedQues", what do I put here???)

Thanks so much.- Hide quoted text -

>- Show quoted text -

Thanks for assisting me I'm all set but have another question...

I have a field in this same database called CDPPin. I'm using a
session variable to get the pin. How do I call it? Do I...

Dim Session (CDPUser)

Then call it like this?

>.Parameters.Ad dWithValue("@Di splayedQues", displayedQues)
.Parameters.Ad dWithValue("@No nDisplayedQues" , nonDisplayedQue s)
. Parameters.AddW ithValue("@CDPP in", CDPPin)?- Hide quoted text -

- Show quoted text -

Thanks so much with you assistance. Just getting back from vacation.