How to get rid of out of range error?

Resign Designs

Hi,

I have this code at page load to and it loads some data from db to form.

try
{
connection.Open();
adapter.SelectCommand = new SqlCommand("select * from mydb order by LangStaticID ASC", connection);
adapter.Fill(ds);
connection.Close();
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
PageTitle.Text = ds.Tables[0].Rows[0].ItemArray[2].ToString();
MetaTitle.Text = ds.Tables[0].Rows[0].ItemArray[3].ToString();

}

when there are no results it gives me this error

How can I handle this error?

tried with this but no luck

if (ds.Tables[0].Rows.Count == 0)
{
//
}

Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vikram Agrawal11y ago
Hi you are getting this exception b'coz your ds (DataSet) does not contain any records. So first verify the row count of ds then use it. like Abrar has given you code.
0
Resign Designs11y ago
I got it to fix by adding an exception handling code
0
Abrar Ahmad Ansari11y ago
why are you doing loop.. no need to do. at a time you want to display one one record right..
use below code. it will handle the error.

if(ds.Tables.Count>0 && ds.Tables[0].Rows.Count>0)
        {
            PageTitle.Text = ds.Tables[0].Rows[0][2].ToString();
            MetaTitle.Text = ds.Tables[0].Rows[0][3].ToString();

        }
0
Sanjeeb Lenka11y ago
check in dataset viewer how may column you got.
0
Resign Designs11y ago
I have 12 columns.Any idea how to handle this error?
by the way it is actually about rows not columns
0
Abrar Ahmad Ansari11y ago
MetaTitle.Text = ds.Tables[0].Rows[0].ItemArray[3].ToString();

how many columns do you have in ur table?
there is no 4 column in ur table that's the reason it caught the error.
0