I want to take Query string parameters sent from another asp.net page and use them to do a sql query. I am getting in where clause variable is being used before assigned. The previous if statements assign the variable. I've included code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim myGroupId As String
Dim myStringMember As String
Dim mySQLQuery As String
If (Request.QueryString("grpI
d") <> Nothing) Then
myGroupId = Request.QueryString("grpId
").ToStrin
g().Trim()
End If
If (Request.QueryString("memI
d") <> Nothing) Then
myStringMember = Request.QueryString("memId
").ToStrin
g().Trim()
End If
mySQLQuery = "SELECT EENAMF, EENAML, EEGRP, EESSN, EECERT, EEIDNO, EEBDMT || '-' || EEBDDY || '-' || EEBDCY || EEBDYR AS BIRTHDT from Loomis.testprod.EMPMSTR WHERE EESSN = ('" & myStringMember & "')" & " and " & "(" & "EEGRP='" & myGroupId & "')"""
SqlDataSourcePersonal.Sele
ctCommand = mySQLQuery
GridViewPersonal.DataBind(
)
End Sub
Start Free Trial