>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?
Obviously the SiteID column is either not being selected into the Table or is being dropped elsewhere before your code runs.
> Is there any other file in addition to the ASPX/ASPX.cs I have to re-check?
Not knowing your environment it's impossible to say. Do you have
business/data layers? Only possible answer is:Trace the code....
Regards,
Viv
>Thanks in advance.