See Attached Codebehind. Anything else you may need to help?
Public Partial Class WebForm24
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
'Uses session variables to perform page authorization
If Not (Session("SESSOINV_A").Equals("6") Or Session
("SESSOINV_B").Equals("5")) Then
Page.Response.Redirect("/Restricted.aspx")
Else
End If
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
EventArgs) Handles Button1.Click
'Converts user input to uppercase for use in database query
tb_Signon.Text = tb_Signon.Text.ToUpper
'Session variable to determine authorization.
If Session("VALUE").Equals("Y") Then
Me.Gridview.SelectCommand = "QUERY1 GOES HERE"
Me.Gridview.SelectParameters.Clear()
Me.Gridview.SelectParameters.Add("FIELD2", tb_Signon.Text)
Me.Gridview.DataBind()
Else
Me.Gridview.SelectCommand = "QUERY2 GOES HERE"
Me.Gridview.SelectParameters.Clear()
Me.Gridview.SelectParameters.Add("FIELD1", Session
("SESSIONV1"))
Me.Gridview.SelectParameters.Add("FIELD2", tb_Signon.Text)
Me.Gridview.DataBind()
End If
End Sub
Protected Sub tb_Signon_TextChanged(ByVal sender As Object, ByVal e
As EventArgs) Handles tb_Signon.TextChanged
'Converts user input to uppercase for use in database query
tb_Signon.Text = tb_Signon.Text.ToUpper
'Session variable to determine authorization. Security Admins
see All, Non-Security Admins see requests as requestor.
If Session("VALUE").Equals("Y") Then
Me.Gridview.SelectCommand = "QUERY1 GOES HERE"
Me.Gridview.SelectParameters.Clear()
Me.Gridview.SelectParameters.Add("FIELD2", tb_Signon.Text)
Me.Gridview.DataBind()
Else
Me.Gridview.SelectCommand = "QUERY2 GOES HERE"
Me.Gridview.SelectParameters.Clear()
Me.Gridview.SelectParameters.Add("FIELD1", Session
("SESSIONV1"))
Me.Gridview.SelectParameters.Add("FIELD2", tb_Signon.Text)
Me.Gridview.DataBind()
End If
End Sub
End Class
On Jun 8, 2:57 pm, Cerebrus <[email protected]> wrote:
> It depends on *when and where* the code you pasted, runs. IOW, we need
> to see more code.
