asked on

voting poll

I have a poll when I test it. no matter what option I select it always votes value 1. not sure whats wrong. and when I add the cookie to record the vote it does not vote at all. But for now I just need to know why it only votes for value one.

stored procedure

(
@Pk_OptionId INT
)

AS
-- GETS THE CURRENT NUMBER OF VOTES FOR THAT OPTION
DECLARE @i_NumberOfVoteS INT

SELECT @i_NumberOfVotes = Votes
FROM PollOptions
WHERE PK_OptionId = @Pk_OptionId

UPDATE PollOptions
SET Votes = (@i_NumberOfVotes + 1)
WHERE PK_OptionId = @Pk_OptionId

RETURN

Protected Sub btnVote_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnVote.Click
RecordVote()

'If Response.Cookies("Voted") Is Nothing Then
' Response.Cookies("Voted").Value = "Voted"
' Response.Cookies("Voted").Expires = DateTime.Now.AddDays(1)

' lblError.Visible = False

' ' Checks if the user can still vote by using cookie
' RecordVote()
'Else
' lblError.Visible = True
'End If
'Response.Write(Response.Cookies("Voted"))
'' Response.Redirect("test.aspx")
End Sub

Private Sub RecordVote()
Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("Conn").ToString()
Dim sqlConn As New SqlConnection(strConnString)

sqlConn.Open()
Dim sqlCmd As New SqlCommand()

sqlCmd.CommandText = "IncrementVote"
sqlCmd.CommandType = Data.CommandType.StoredProcedure
sqlCmd.Connection = sqlConn

' Creation parameters
Dim sqlParamQuestion As New SqlParameter("@PK_OptionId", Data.SqlDbType.Int)

sqlParamQuestion.Value = rdoPollOptionList.SelectedValue

sqlCmd.Parameters.Add(sqlParamQuestion)

' Execute stored procedure
sqlCmd.ExecuteNonQuery()

' Close connection
sqlConn.Close()
End Sub

guru_sami

Here are troubleshooting options:
1: Execute your StoredProc directly from SqlServer and see if it is working as desired.
2: set breakpoint at line:
------> sqlParamQuestion.Value = rdoPollOptionList.SelectedValue
Confirm the "rdoPollOptionList.SelectedValue" has desired value.

Post your observations.
Now a question: How is your rdoPollOptionList DataBound? i.e. dynamically in code-behind?
If so post that code....make sure that you DataBind it once only i.e. Not Page.IsPostBack.

Seven price

ASKER

I excuted the stored procedure that works great.

I used
If Page.IsPostBack Then
' RecordVote()
Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("Conn").ToString()
Dim sqlConn As New SqlConnection(strConnString)

sqlConn.Open()
Dim sqlCmd As New SqlCommand()

sqlCmd.CommandText = "IncrementVote"
sqlCmd.CommandType = Data.CommandType.StoredProcedure
sqlCmd.Connection = sqlConn

' Creation parameters
Dim sqlParamQuestion As New SqlParameter("@PK_OptionId", Data.SqlDbType.Int)

sqlParamQuestion.Value = rdoPollOptionList.SelectedValue

sqlCmd.Parameters.Add(sqlParamQuestion)

' Execute stored procedure
sqlCmd.ExecuteNonQuery()

' Close connection
sqlConn.Close()

instead of not Page.ispostback because the other way did not execute.

But it only finds Value 1 not value 2, 3 ect.

ASKER CERTIFIED SOLUTION

guru_sami

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Seven price

ASKER

Private Sub DisplayPoll()
Try
Dim ds As DataSet = getActivePoll()

' Displays the poll
lblPollQuestion.Text = ds.Tables(0).Rows(0)("Question")

Dim i As Integer = 0
For Each dr As DataRow In ds.Tables(1).Rows
rdoPollOptionList.Items.Add(dr("Answer"))
rdoPollOptionList.Items(i).Value = dr("PK_OptionId")
rdoPollOptionList.SelectedIndex = 0

i = i + 1
Next
Catch ex As Exception
Throw ex
End Try

End Sub

Seven price

ASKER

The radio button is getting the option value from the database.

guru_sami

where are you calling this DisplayPoll() ?
Put the Call to this method in If Not Page.IsPostBack

Seven price

ASKER

Anythingin your Page_Load method? found it thanks