Click here to Skip to main content
15,905,414 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
VB
For Each dr1 In reportData.Tables(0).Rows

                Dim con4 As New SqlConnection("Data Source=INSIGHT-002;Initial Catalog=TNVKP_8;user id=sa;")
                con4.Open()
                Dim cmdclustr As New SqlCommand("select ParentUnitID from M_RptUnit where Rpt_Unit_ID='" + dr1("VPRC_ID") + "'", con4)
                Dim redclustr As SqlDataReader
                redclustr = cmdclustr.ExecuteReader()

                If (redclustr.Read()) Then
                    clusterid = redclustr("ParentUnitID")
                    Dim login As String
                    login = Convert.ToString(Session(ssnLOGIN_ID)).ToUpper()
                    'If ((Convert.ToString(redclustr("ParentUnitID"))).ToUpper() = (Convert.ToString(Session(ssnLOGIN_ID))).ToUpper()) Then
                    Response.Write(login)
                    Response.Write(clusterid)
                    'Response.End()
                    If clusterid.ToString() = login.ToString() Then
                        check = 1
                        Response.Write("HAI HAI")
                        Response.Write(check)
                        Response.End()
                    Else
                        check1 = 2
                        Response.Write(check1)
                        Response.End()
                    End If
                End If
                redclustr.Close()
            Next

From the above code i m having an error
Always it executing the else part(CHECK1=2) post solution for this
Thanks in advance
Posted
Updated 19-Dec-11 21:31pm
v2
Comments
Pramod Harithsa 20-Dec-11 3:36am    
check the values of clusterid and login at the last "if"
Sergey Alexandrovich Kryukov 20-Dec-11 3:37am    
Off-topic. This site is for software developers, who use the Debugger :-)
--SA

1 solution

Just run it under debugger and track all assignments to both clusterid and login.
Trivial, yes, but you don't show all relevant code, and this is the regular and simple way to solve such simple problems. Always do it before you ask a question.

—SA
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900