Try using group by in query. SELECT stateid, MAX(stateid) as "MAX id" FROM states GROUP BY stateid

Regards, Saqib Umar Sr. Software Engineer

If master page contains the style definition for the grid in app_theme folder then your style defined in page can't take precedence over skin/style in theme folder. You can apply a theme as a style sheet theme by setting the page's StyleSheetTheme property. In this case, local page settings take precedence over those defined in the theme when the setting is defined in both places. This is the model used by cascading style sheets. You might apply a theme as a style sheet theme if you want to be able to set the properties of individual controls on the page while still applying a theme for an overall look. You can add one or more .css files into a theme directory. ASP.NET will automatically apply all of a theme’s style sheets into a page by injecting a element for each .css into the header of a page. Your page must have runat=”server” in the Regards, Saqib Umar Sr. Software Engineer

Yes you can export data directly from SQL to xls file without displaying it in grid. Excel can be treated as SQL using connection string like following : "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=/book1.xls;UID=admin;" rows and colums are treated as html and or . I've done this work 3 years back on classic ASP. Don't get confused by the syntax. Cheers!

Regards, Saqib Umar Sr. Software Engineer

See the following link. This might help you. http://www.codeproject.com/csharp/ObjectPooling.asp[^]

Regards, Saqib Umar Sr. Software Engineer

Email attachment and uploading file from one server to another server are two seperate things. I would recommend to use upload functionality if content is needed to be transferred from server to server rather than email. Regards, Saqib Umar Sr. Software Engineer AMZ Access(Pvt) Ltd