About Ashvin Expertise I can handle all the queries related to XML. I can sort out problems regarding XSLT and XSL. I work using MSXML components. I can handle XML-SQl, XML-VB and XMl-ASP related queries.
Experience I have worked for 2years in this feild. I have worked in SGML and DTDs, and now working in XML and Schemas.
I have gone through your code, I am not able to understand how you are getting your XML from the database. I mean to say which language you used for the XML output. It can be done with SQL Query itself and also by using some scripting language. So it will be good if you send me the remaining code for retrinving XML for the Database. I can help you in better way.
Thanks for asking
Take care
I'm using VB.Net for my application. Here is my basic code:
Dim strConnectionString As String = "My database connection"
Dim strQuery As String = "execute sp_StoredProcedure"
Dim myDataset As DataSet = New DataSet
Dim mySqlConnection As New SqlConnection(strConnectionString)
Dim mySqlDataAdapter As New SqlDataAdapter
'Get query results
mySqlDataAdapter.SelectCommand = New SqlCommand(strQuery, mySqlConnection)
mySqlDataAdapter.Fill(myDataset)
myDataset.WriteXML("Results.xsl")
Basically I create a dataset, call a stored procedure and fill the dataset with the results. I just call 'myDataset.WriteXML("Results.xsl")' and .Net does the rest. Does this help?
Answer Hi Don,
You can get XML as per your requirement.
I have tried your code and get the value in same structure what you are asking for with your same code only.
