Problem with response.redirect
i m trying to pass a value from datagrid to a querystring as below...
Response.Redirect("review.aspx?id= " & e.Item.Cells(0).Text)
and also receiving the value as
cid = Request.QueryString("id")
but somehow the database query is not working with this id as i m trying like
Dim con As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Try
con = New OleDbConnection(ConfigurationSettings.AppSettings("constring"))
con.Open()
cmd = New OleDbCommand("select cfname,clname from tblcust where cid = '" & cid & "'", con)
Response.Write(cmd.CommandText)
dr = cmd.ExecuteReader()
If dr.Read Then
Response.Write("its " & dr("cfname") & " " & dr("clname") & "'s review! ")
End If
con.Close()
dr.Close()
Catch ex As Exception
Response.Write(ex.Message)
con.Close()
End Try
but same database query is properly working if i send the querystring thru datanavigateurlformatstring as
DataNavigateUrlFormatString="review.aspx?id={0}"
from the aspx page
Pls tell me why the querystring coming from response.redirect is not working?

