>>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).aspxTrue. But why do you mention this?
Regards,
Viv