Hello,(Thanks for your time)

I'm getting the following runtime error message:

RowId

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: RowId

Source Error:

Line 125: pid = Convert.ToInt32(reader["RowId"]);

Stack Trace:

[IndexOutOfRangeException: RowId]

--------------
I get this error sometimes,But sometimes it works fine.

I have checked all the columns in the select statement, it contains RowID.

-i dont know where it went wrong.

me select statemet:

SELECT F.RowId, F.PredictionTopic, F.Memlgname, F.MemPrediction, F.UknowY,F.PredictedDate, C.Memvote, C.MemComments, C.CommUserName, C.CommentedDate FROM Forumtable
AS F LEFT OUTER JOIN CommentTable AS C ON F.RowId = C.RowId ORDER BY F.PredictedDate desc

-Thanks
-Appreciate your help

-

I think you need to supply more information and code. AFAIK, the IndexOutOfRange exception could only occur when the column is missing. Maybe the SQL is dynamic and in some cases the column is indeed missing? Or maybe you get multiple result sets back?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Is this piece of code is in loop. Check the boundary condition , there might be chances that while execution of the above statement it was going out of boundary.

could you please put full code of your function.