SqlDataReader out of range exception.. cannot solve it

Question

I have been trying to get it working for almost an hour now and cannot make any sense why it is not working. Please help!! This is my code

SqlDataReader rs = cmdGet.ExecuteReader();
rs.Read();
var id = Convert.ToInt32(rs["id"]);
var mt = rs["mt"].ToString();

The SQL statement is this:

  SELECT TOP 1 
      id = 0,
      mt = MT
  FROM 
      MyTable
  ORDER BY 
      2

I id = 0 and the code breaks at mt line. Throws:

System.IndexOutOfRangeException

What's wrong? I looked at a lot of posts but could not resolve it.

id = 0? Huh? What is that doing? Have you tried running that query in something like SSMS to see what you get? — itsme86
– itsme86, Commented Feb 10, 2017 at 22:35
What does your table actually look like? It difficult to discern exactly what you are trying to do in your current query. — Rion Williams
– Rion Williams, Commented Feb 10, 2017 at 22:38

Saif · Accepted Answer · 2017-02-10 22:58:52Z

1

the exception said that you have no field named mt so you need to change your query into this and it should work:

SELECT TOP 1 id, mt
FROM MyTable
 WHERE id = 0
ORDER BY 2

answered Feb 10, 2017 at 22:58

Saif

2,8093 gold badges22 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

my pleasure to help you :)