sql data to xml [modified]
-
I have a vb.net web application. I have to convert the data from sql database to xml format. I am a newbie to xml so please guide me how to go about it. I have read samples about how to fill a dataset (use a query to get data from db and fill dataset)with data and transfer that into xml format. The problem with this approach is our xml template has many nested rows. Something like somedata somedata somedata somedata somedata I understand we have to use schemas to define datatype , the min occurence and max occurence and mandatory fields please let me know if it is correct? Also I am not sure what approach must be used i don' t know whether to use xsl ot xsl fo to transform the xml output according to the template. -- modified at 6:54 Tuesday 20th June, 2006