I have no idea what the problem is here - especially because this code seemingly worked a few hours ago (though maybe I changed something small).

I'm trying to read from the querystring an integer value. Based on the querystring's content, I do a lookup in the database and present a different page to the user. For instance, http://localhost/wjer03/content.aspx?page=1 uses a Stored Proc to Select the record where the contentID is '1'. However, I keep getting 'Input string was not in a correct format'. Here's my code - any ideas?

  Public Sub DisplayContent()

    Dim qsPage As String = Request.QueryString("page")
    Dim cn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("C onnString"))
    Dim cmdContent As SqlCommand = New SqlCommand("ViewContent", cn)

    cmdContent.CommandType = CommandType.StoredProcedure
    cmdContent.Parameters.Add("@pageRequested", SqlDbType.Int).Value() = qsPage

    cn.Open()

    Dim rdrContent As SqlDataReader

    listContent.DataSource = cmdContent.ExecuteReader()
    listContent.DataBind()

    cn.Close()

  End Sub

Dim qsPage As String = Request.QueryString("page")

Try changing it to Integer

I tried that earlier, and that didn't work - plus, querystring info is always supposed to be initially captured as a string. Also, it was working just fine initially calling qsPage as a string, so the problem needs to be elsewhere...

Can you post the integer conversion you tried that you say didn't work? If the parameter in SQL is an INT, then just sending in the QS value directly won't work regardless of the fact that you don't get a design-time or build error. You need to convert.

cmdContent.Parameters.Add("@pageRequested", SqlDbType.Int).Value() = CType(qsPage, Integer)

Peter
------------------------------------------------------
Work smarter, not harder.

I've tried all sorts of conversions on that line, including the one you just suggested - but all it does it give me the same error, this time on that cmdContent.Parameters.Add line (formerly it gave me the error on the ExecuteReader() line.

I'm beginning to think this might be a bug in the framework...it simply won't let me convert the freakin' data type..

Let's see your Stored Procedure.

Is the error you are getting coming from SQL or .net? You provided the error text, but didn't specify the source. This has a large impact on our suggestions.

Is the data type for @pageRequested in the sproc correct? Is the use of that var within the sproc correct?

Peter
------------------------------------------------------
Work smarter, not harder.

It looks like the error is coming from .NET, not the sproc. I am getting the error on the ExecuteReader() line; to isolate the problem, I removed the sproc and threw the SQL query into the asp.net code, to no avail.

The @pageRequested var is called as an Int, so that shouldn't be a problem...I would be so bold as to say there is no way the problem can be in the sproc.

Is it possible this is a bug with DataReaders?

Here it is:
Here's my Stored Procedure, it looks fine to me:

CREATE PROCEDURE dbo.ViewContent
(
@PageRequested NVarChar
)
As
(
SELECT * FROM siteContent WHERE contentID = @PageRequested
)
GO

Yes, it looks fine but it expects an NVarchar, not an Int. So you should change:

("@pageRequested", SqlDbType.Int

to

("@pageRequested", SqlDbType.NVarChar


I was actually going to ask what those parentheses were doing after the Value when your message with the Sproc came in. Instead, try to create a parameter explicitly, assign its value and then add it to the Parameters collection.

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.