Hi, I need to send a recordset to a webservice, where i have to convert it to dataset and process. For that I thought of converting this recordset to xml and sent it to the webservice. THere in teh webservice again convert the incoming xml to dataset. Can anyone please help me in this. Please also tell me how to convert a recordset to a dataset

Not enough information. Does the recordset and the dataset reside on the same server? What are the file types of the recordset and dataset? If you have noticed the ASP.NET databases Using VB.NET the Northwind DB (SQL) is used as a recordset and a dataset, so it is not clear what you are trying to accomplish, especially to "process" the file.

Hi Kishore,
  For converting Recordset To XML, Use 'FOR XML AUTO' clause in SQL query.
and Again For reading XML File, use DataSet.ReadXML() function.
  I think, For transferring data to web service, you should use XML format.


Thanks & Regards
-Sandip