Thanks, Rob. This looks really juicy and I definitely would like to create a datatable so I am going to study your code carefully as this is new to me.

I did, however, finally plumb they mysteries of goldlasso.anyTypeArray. Looks pretty proprietary in functionality.

Here is the code that actually works so far :

Created this for testing - and also to examine the contents of the data on the back end. Definitely want to expand it.

Thanks everyone - I'm sure I'll be back after reading Paul's message ( which I must have missed on the last pass ) and trying Rob's datatable code

      public void RunQuery(string query, int limit, int offset, string filename)
        {
            anyTypeArray1[] result = null;
            result = this.Proxy.runQuery(query, limit, offset);
            if (result.Length > 0)
            {
                TextWriter twr = new StreamWriter(filename);

                twr.WriteLine("Limit " + limit.ToString() + "  " + query);
                twr.WriteLine(result.Length.ToString() + " records returned");
                int itemlength = result[0].item.Length;

                for (int i = 0; i < result.Length; i++)
                {
                    anyTypeArray1 rec = result[i];
                    string newline = "";
                    for (int j = 0; j < itemlength; j++)
                    {
                        string newstring = "";

                        if (rec.item.GetValue(j) == null)
                            newstring = "(null)";
                        else
                            newstring = rec.item.GetValue(j).ToString();

                        if (j < itemlength - 1)
                            newstring += ",";

                        newline += newstring;
                    }
                       twr.WriteLine(newline);
                }
                twr.Close();
            }
        }

>If you are looking to create a DataTable, the following might work:
>

>DataTable newTable = new DataTable();
>
>if (result.Any())
>{
>    // Assume all rows have the same structure, use the first to create the columns
>    var rowForColStructure = result.OfType<GLWebService.goldlasso.anyTypeArray1>().First();
>
>    // Create the structures with a generic name
>    DataColumn[] columns = rowForColStructure.item.Select((item, index) => new DataColumn(string.Format("Column{0}", index), item.GetType())).ToArray();
>    // Add the columns to the table                
>    newTable.Columns.AddRange(columns);
>    
>    // New rows get added when the query is executed via the ToList
>    var rows = result.OfType<GLWebService.goldlasso.anyTypeArray1>().Select(item => newTable.Rows.Add(item.item)).ToList();
>}
>

>
>The items would still be in their original types. If you need it as strings, change it to:
>

>DataTable newTable = new DataTable();
>
>if (result.Any())
>{
>    // Assume all rows have the same structure, use the first to create the columns
>    var rowForColStructure = result.OfType<GLWebService.goldlasso.anyTypeArray1>().First();
>
>    // Create the structures with a generic name
>    DataColumn[] columns = rowForColStructure.item.Select((item, index) => new DataColumn(string.Format("Column{0}", index), typeof(string))).ToArray();
>    // Add the columns to the table                
>    newTable.Columns.AddRange(columns);
>    
>    // New rows get added when the query is executed via the ToList
>    var rows = result.OfType<GLWebService.goldlasso.anyTypeArray1>().Select(item => newTable.Rows.Add(item.item)).ToList();
>}
>