thats great thank ye

thats great thanks

Thank you for your help but it is only allowing me to select 'equals/gethashcode/getstring/tostring from the telesense inside the 2d and 3rd foreach loop, stating object does not contain a defination for...

 if (result != null)
        {
            foreach (var table in result.Tables)
            {
                foreach (var col in table.Columns)//wont allow me to select columns
                {
                    //...
                }

                foreach (var row in table.Rows)//wont allow me to select rows
                {
                    object[] values = row.ItemArray;
                    //...
                }
            }
        }

any suggestions as to why?

iv also tried
if (table != null && table is Table)
{

Again, thank you for the reply but neither has worked, any more suggestions?

thank you for the help but this has not helped, any other suggestions?