Query String

[mustafa127in]

I tried to pass the 2 value from by home page in below code to my target page

Response.Redirect("editclass.aspx?Requestor=" &
       TextBox1.Text & "&Lower= " & lblAllocation.Text)
        Response.Redirect("editclass.aspx?" + TextBox1.Text)
 
on target page i retrived my values like below 
lblejamaatidrequest.Text = Request.QueryString("Requestor")
lblAllocation.Text = Request.QueryString("Lower")
 

both has worked fine but when i tried to search my data using below commands i get nothing what i have done wrong

 Dim Conn As OleDbConnection
        Conn = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;" & _
                                     "Data Source=d:\student2003.mdb")
        Conn.Open()
 
        Dim DataReader As OleDbDataReader
        Dim Command As OleDbCommand
 
        Command = New OleDbCommand("SELECT Student_Details.[EJamaatID], Student_Details.[FullName], Student_Details.[Sex], Student_Details.[Age], Student_Details.[email], Student_Details.[Mobile],  Student_Details.[Allocation] FROM Student_Details WHERE   Allocation=@Allocation And EJamaatID=@EJamaatID", Conn)
 
        Command.Parameters.Add(New OleDbParameter("@Allocation", lblAllocation.Text))
        Command.Parameters.Add(New OleDbParameter("@EJamaatID", TextBox3.Text))
        Try
            DataReader = Command.ExecuteReader()
            GridView1.DataSource = DataReader
            GridView1.DataBind()
            GridView1.Visible = True
 
        Catch ex As Exception
            MsgBox(Err)
        End Try
        Conn.Close()

[ariful alam]

In first code block you used lblejamaatidrequest.Text and lblAllocation.Text to store your query string value.

In second code block you are using lblAllocation.Text and TextBox3.Text as value for database query parameter.

from where you get the value @ TextBox3.

can you clear this