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...