SQL queries to XML export RSS

• • Reply
  gaby58

  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);

• • Reply
  Rajsasp

  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