On Thu, Mar 15, 2012 at 9:57 AM, Chuck <[email protected]> wrote: > I don't have code in front of me to explain in detail, but can't you > step through the dataset and add some sort of String.Format (assuming > you're using C# here - it looks like you are)? > > Example for string format. > http://stackoverflow.com/questions/418822/asp-net-negative-numbers-in-parenthesis > > Examples for cycling through dataset > http://bytes.com/topic/c-sharp/answers/251798-loop-through-dataset-get-values-vb-net > http://social.msdn.microsoft.com/Forums/zh/csharpgeneral/thread/0866d84c-b22c-4d68-9769-b51eb2d3955a ----------------------
I don't think that would be a good thing because that value is now considered TEXT and a sort or SUM() will not comprehend the true value. The requester is attempting to sling pure text to the user and append a header for the browser to load the text into excel. If the user were going to make the file locally on the server, adjust the column formatting and then push that file it would work. Oh yeah this gets expensive to load Excel on a server! > A few minutes of Google search may very well help you in this case. > > FYI: if you're passing this dataset to a gridview of some sort, you > may very well be able to export the gridview itself, and do all your > formatting on the gridview - which sounds like you're doing that > already. -------------------------------- -- Stephen Russell 901.246-0159 cell -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
