iterating thru datatables collection

[=?Utf-8?B?cm9kY2hhcg==?=]

hey all,
i have a loop like the following:

foreach(DataTable dt in DataTablesCollection1)
{
if(dt[0][0].ToString().Contains("something")
{
//do something
}
}

the problem is when i get an empty datatable and it doesn't find a row at
the position in the if statement. how do you avoid something like that?

thanks,
rodchar

[Alberto Poblacion]

"rodchar" <ro*****@discussions.microsoft.comwrote in message
news:68**********************************@microsof t.com...

hey all,
i have a loop like the following:

foreach(DataTable dt in DataTablesCollection1)
{
if(dt[0][0].ToString().Contains("something")
{
//do something
}
}

the problem is when i get an empty datatable and it doesn't find a row at
the position in the if statement. how do you avoid something like that?

Add a statement to check the number of rows:

if (dt.Rows.Count>0) ...

[Pete Kane]

rodchar wrote:

hey all,
i have a loop like the following:

foreach(DataTable dt in DataTablesCollection1)
{
if(dt[0][0].ToString().Contains("something")
{
//do something
}
}

the problem is when i get an empty datatable and it doesn't find a row at
the position in the if statement. how do you avoid something like that?

thanks,
rodchar

put another if before

if(dt[0][0].ToString().Contains("something")

like

if(dt[0].Rows.Count 0)

[Mark Peters]

>the problem is when i get an empty datatable and it doesn't find a row at

>the position in the if statement. how do you avoid something like that?

if (dt.Rows.Count == 0) {// Do something else; continue;}

try/catch maybe?

How expected is an empty table?
What are you trying to do?

[=?Utf-8?B?cm9kY2hhcg==?=]

thanks everyone for the help,
rod.

"rodchar" wrote:

hey all,
i have a loop like the following:

foreach(DataTable dt in DataTablesCollection1)
{
if(dt[0][0].ToString().Contains("something")
{
//do something
}
}

the problem is when i get an empty datatable and it doesn't find a row at
the position in the if statement. how do you avoid something like that?

thanks,
rodchar