IndexOutofRangeException :There is no row at position 0

c# .net indexoutofrangeexception
hshantanu picture hshantanu · Apr 16, 2014 · Viewed 7.3k times · Source

I am trying to design a mini project of a quiz application using resource bundle. I get an error of There is no row at position 0 when I insert the following if condition. Where I am catching the string from combobox in variable X.

SampleResourceBundle.Loginpage l = new SampleResourceBundle.Loginpage();
if(l.x.Equals("mr_IN"))
   sql = "select * from quesans where qid>48";
else if (l.x.Equals("en_US"))
   sql = "select * from quesans where qid<48";

The error is given in the following statement in the method from the next form:

textBox1.Text = ds.Tables["QA"].Rows[recno].ItemArray[2].ToString();

But if I remove the if statement the code executes perfectly fine.

Answer

Szymon picture Szymon · Apr 16, 2014

There are no rows in ds.Tables["QA"].

You need to check if there is a row you want to read before attempting it:

if (recno < ds.Tables["QA"].Rows.Count)
    textBox1.Text = ds.Tables["QA"].Rows[recno].ItemArray[2].ToString();

Related questions

What is an "index out of range" exception, and how do I fix it?

I'm getting one of the following errors: "Index was out of range. Must be non-negative and less than the size of the collection" "Insertion index was out of range. Must be non-negative and less than or equal to size." "Index …

Read More
What is an IndexOutOfRangeException / ArgumentOutOfRangeException and how do I fix it?

I have some code and when it executes, it throws a IndexOutOfRangeException, saying, Index was outside the bounds of the array. What does this mean, and what can I do about it? Depending on classes used it can also be …

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More