Problem with ADO.NET...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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, O.offName
FROM tblOfficePageContent R
INNER JOIN tblOffice O ON
R.officeID = O.officeID
INNER JOIN tblPageContent P ON
R.pageID = P.pageID
AND P.pageID = @pageID
GO
 
OK!

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

Thanks for the reply!
 
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
 
Eliyahu said:
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
Click to expand...

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