Solved

sql2005 for xml raw sending untyped data to asp.net

Posted on 2010-09-01
1
298 Views
Last Modified: 2012-05-10
i have sql that uses FOR XM RAW to generate xml for my asp.net application to use to bind grids to and things like this.

the problem is that the date data is not taking the gridView formatting of the date because (and im taking a crack at this) the date value in the xml is a string and the formatting is not taking.

any thoughts on how to get this to work?

i like using xml because i can persists it to a log table and trace all the xml sent in and out. i would hate to loose this...
0
Comment
Question by:realcoding
1 Comment
 
LVL 2

Accepted Solution

by:
SrinathKomirishetty earned 500 total points
ID: 33583734
Try this:
1.  Format the column within the rowdatabound event
DateTime d;  
int cellNo=2;
 if (DateTime.TryParse(e.Row.Cells(cellNo).Text,out d)) {  
     e.Row.Cells(cellNo).Text = d.ToString("MM/dd/yyyy");  
or
2. Label.Text='<%# Eval("DateField", "{0:M-dd-yyyy}") %>'
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question