How to get rid of out of range error?

Question

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

Vikram Agrawal · Answer

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.

Resign Designs · Answer

I got it to fix by adding an exception handling code

Abrar Ahmad Ansari · Answer

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(); }

Sanjeeb Lenka · Answer

check in dataset viewer how may column you got.

Resign Designs · Answer

I have 12 columns.Any idea how to handle this error? by the way it is actually about rows not columns

Abrar Ahmad Ansari · Answer

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.