Why, why, why???

[Tim::..]

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'.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:80**********************************@microsof t.com...

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

[Tim::..]

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" wrote:

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'.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:80**********************************@microsof t.com...

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]

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.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:8B**********************************@microsof t.com...

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" wrote:

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'.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:80**********************************@microsof t.com...

> 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

[Patrice]

How do you know it's "nothing" ?

Patrice

--

"Tim::.." <myatix_at_hotmail.com> a écrit dans le message de
news:8B**********************************@microsof t.com...

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" wrote:

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'.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:80**********************************@microsof t.com...

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

[Tim::..]

OK!
Thank you...

"Marina" wrote:

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.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:8B**********************************@microsof t.com...

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" wrote:

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'.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:80**********************************@microsof t.com...
> 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

[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
===========
"Tim::.." <myatix_at_hotmail.com> wrote in message
news:0B**********************************@microsof t.com...

OK!
Thank you...

"Marina" wrote:

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.

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:8B**********************************@microsof t.com...

> 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" wrote:
>
>> 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'.
>>
>> "Tim::.." <myatix_at_hotmail.com> wrote in message
>> news:80**********************************@microsof t.com...
>> > 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
>>
>>
>>