>Hi everybody,
>
>I am working on a complex web page that I originally copied from existing. I made bunch of the adjustments in it to point to the correct table. This page has a GridView with SQLDataSource and also DataSet is created in code.
>
>I verified that all my SELECT statements in ASPX and aspx.cs for that page include the SiteID field (I added it).
>
>However, in the method that creates an Excel file from it I have the following code:
>
>

>DataSet dtsCopy = dts.Copy();
>
>            dtsCopy.Tables[0].Columns.Remove("lettercode");
>            dtsCopy.Tables[0].Columns.Remove("SiteID");
>            dtsCopy.Tables[0].Columns.Remove("deleted");
>

>
>and the second line is failing (Column SiteID is not found).
>
>Do you know where can I find why I don't have SiteID in the DataSet? Is there any other file in addition to the ASPX/ASPX.cs I have to re-check?
>
>Thanks in advance.
_________

The help file says that Columns is a collection

see: http://msdn.microsoft.com/en-us/library/system.data.datacolumncollection.contains(VS.71).aspx