Problem with ADO.NET...

[Guest]

Can someone please tell me why I keep getting the following error???

Input string was not in a correct format.

I keep getting the following error on:

fldTitle.Text = myReader.GetString("header")

I would be really grateful for any advice anyone might have! Thanks



<code>
Dim Myconn As New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
Dim cmd As New SqlCommand("PageProperties", Myconn)
cmd.CommandType = CommandType.StoredProcedure


Myconn.Open()

Dim objPageID As SqlParameter
objPageID = cmd.Parameters.Add("@pageID", SqlDbType.Int)
objPageID.Direction = ParameterDirection.Input
objPageID.Value = 1 'pageID


Dim myReader As SqlDataReader = cmd.ExecuteReader()
While myReader.Read
fldTitle.Text = myReader.GetString("header")
End While

myReader.Close()
</code>

Store Procedure...

CREATE PROCEDURE dbo.pageProperties
(
@pageID Int
)

AS

SELECT P.pageID, P.creationDate, P.modificationDate, P.description,
P.header, P.content, P.keywords, P.Status, ffName
FROM tblOfficePageContent R
INNER JOIN tblOffice O ON
R.officeID = fficeID
INNER JOIN tblPageContent P ON
R.pageID = P.pageID
AND P.pageID = @pageID
GO

 

[Eliyahu Goldin]

GetString takes in integer as a parameter.

Eliyahu

 

[Guest]

OK!

But how do I retrieve the values of those columns from my Stored Procedure???

Thanks for the reply!

 

[Eliyahu Goldin]

A result record set generated by your stored procedure is the result of an
regular select statement. Columns are return in the order they are listed in
the select. In your case it will be

fldTitle.Text = myReader.GetString(4)

Eliyahu

 

[Hans Kesting]

A result record set generated by your stored procedure is the result of an
regular select statement. Columns are return in the order they are listed in
the select. In your case it will be

fldTitle.Text = myReader.GetString(4)

Eliyahu

and there is myReader.GetOrdinal("header"), which should
return the "4"