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.