Hi ,
I have sqlxml data generated by sqlserver 2008. Columns in sqlxml may vary every time based on some parameters.
Now I want to use asp.net xsl to transform my sqlxml data. But the problem is I don't know how to generate my xsl file as I cannot hard code the column names because if there are few columns in my sqlxml data then rest columns specified on xsl will go Null
and will increase file size.
I want something which can automatically format my sqlxml only for the given columns so that i can save it into excel format without any extra columns.
Can you please suggest if it is possible using xsl formatting or i should be using something else? let me know if you need more information.
I am using .Net 3.5 via VS2008 for UI.
Thanks,
Sandeep
Go to the complete details ...