Displaying data in xml format from SqlDB

• • Reply

  14 years ago

  by VRaju

  Raju

  , India

  Joined 14 years ago

  Hi All,

  I Have a problem with displaying data in xml format. I have a table name "Service" in SqlDB with "ServiceID" , "ServiceName","ServiceDesc","ServiceAva" these fields. From the client application i am passing "ServiceID" as input to the Webservice. The webservice have to display data to the client in the xml format. i don't want to use the xml mode in the sql query. The output should be like this.

  <Service>

  <ServiceID DATA_TYPE="int">5</ServiceID>

  <ServiceName DATA_TYPE="nvarchar">5</ServiceName>

  <ServiceDesc DATA_TYPE="nvarchar">5</ServiceDesc>

  <ServiceAva DATA_TYPE="int">50</ServiceAva>

  </Service>

   

  Can you all please help me.

  Regards

  Raju

  Report abuse