I have these queries written in asp.net pages, these should be exported as xml format how to do this? Thanks for any tips
SqlCommand cmdTOPSuppliers = new SqlCommand(
"SELECT "
+ "SUM(TotalValue) AS TotalSpend, Count(DISTINCT WellId) AS WellCount FROM tbl_view_WellProductlines2 WHERE SpudDate BETWEEN '"
+ strSDS + "' AND '" + strSDE + "' And Operator IS NOT NULL AND "
+ strR + "Id IN(" + strId
+ ")" + HCS + " GROUP BY "
+ strR + " ORDER BY TotalSpend DESC",
conTOPSuppliers);
Member
12 Points
207 Posts
SQL queries to XML export
Dec 31, 2013 09:50 AM|gaby58|LINK
Hi All,
I have these queries written in asp.net pages, these should be exported as xml format how to do this? Thanks for any tips
SqlCommand cmdTOPSuppliers = new SqlCommand(
"SELECT "
+ "SUM(TotalValue) AS TotalSpend, Count(DISTINCT WellId) AS WellCount FROM tbl_view_WellProductlines2 WHERE SpudDate BETWEEN '"
+ strSDS + "' AND '" + strSDE + "' And Operator IS NOT NULL AND "
+ strR + "Id IN(" + strId
+ ")" + HCS + " GROUP BY "
+ strR + " ORDER BY TotalSpend DESC",
conTOPSuppliers);
Participant
761 Points
264 Posts
Re: SQL queries to XML export
Dec 31, 2013 10:09 AM|Rajsasp|LINK
You can follow below link.
http://forums.asp.net/t/1580193.aspx
Thank You