Why, why, why???

[Guest]

Hi...

Can someone please tell me why my querystring isn't returning anything!

I have a called viewpage.aspx that contains a datagrid with the following
linkcolumn

<asp:hyperlinkcolumn DataNavigateUrlField="pageid"
DataNavigateUrlFormatString="editor.aspx?id={0}" Text="<img border=0
src=../images/edit.gif alt=Edit Page>">

When I run the code the id is sent to editor.aspx which is visable in the
address bar so I know it is working. However when I try to request the
querystring it returns rowID=0

WHY???

Would appritiate any advice... thanks

CODE..

Private rowID As Integer = 1

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

'Get Text for Editor
If Not Page.IsPostBack Then
rowID = CType(Request.QueryString(ID), Integer)
FreeTextBox1.Text = GetDocument()
End If


End Sub 'Page_Load

Public Sub Button_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
UpdateDocument(FreeTextBox1.Text)
End Sub 'Button_Click

Private Function GetDocument() As String
Dim ds As DataSet = GetDataSet(("SELECT content FROM tblPageContent
WHERE pageID=" + rowID.ToString()))
Dim table As DataTable = ds.Tables(0)
Dim row As DataRow = table.Rows(0)
Dim doc As String = row("content").ToString()
Return doc
ds.Dispose()
End Function 'GetDocument

 

[Marina]

You are indexing by ID. What is ID. Is this a variable you have defined
somewhere? What is its value?

You need to use Request.QueryString("id"), to get the value of the variable
called 'id'.

 

[Guest]

Thanks! I was missing the quotes!


Can you then explain why the variable rowID resets itself to equal nothing
when it hits this function!

Thanks

Private Sub UpdateDocument(ByVal doc As String)
Dim strSQL As String = ""
strSQL += "UPDATE tblPageContent SET content='"
strSQL += (doc.Replace(Chr(39), Chr(39) + Chr(39)))
strSQL += "' WHERE pageID=" + rowID.ToString()
RunQuery((strSQL))
End Sub 'UpdateDocument

 

[Marina]

An integer variable can never be nothing. It can be 0, it will never be a
null reference.

If you are setting the variable to a query string variable that wasn't
found, then casting nothing to an integer will result in your integer
variable being set to 0.

You can't post little separate snippets and ask why the variable got set to
nothing, or anything else. Any number of pieces of code could have run
before this function was hit that could have changed it. We don't know what
you have.

 

[Patrice]

How do you know it's "nothing" ?

Patrice

--

Thanks! I was missing the quotes!


Can you then explain why the variable rowID resets itself to equal nothing
when it hits this function!

Thanks

Private Sub UpdateDocument(ByVal doc As String)
Dim strSQL As String = ""
strSQL += "UPDATE tblPageContent SET content='"
strSQL += (doc.Replace(Chr(39), Chr(39) + Chr(39)))
strSQL += "' WHERE pageID=" + rowID.ToString()
RunQuery((strSQL))
End Sub 'UpdateDocument

 

[Guest]

OK!
Thank you...

An integer variable can never be nothing. It can be 0, it will never be a
null reference.

If you are setting the variable to a query string variable that wasn't
found, then casting nothing to an integer will result in your integer
variable being set to 0.

You can't post little separate snippets and ask why the variable got set to
nothing, or anything else. Any number of pieces of code could have run
before this function was hit that could have changed it. We don't know what
you have.

 

[Juan T. Llibre]

Tim,

although this is an ASP.NET newsgroup, and your
question does constitute an ASP.NET code issue,
did you know that questions about FreeTextBox
coding will probably have a better chance of being
expertly answered at the FreeTextBox Forums ?

http://www.freetextbox.com/forums/




Juan T. Llibre
ASP.NET MVP
===========