Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 28, 2012 04:58 PM by steve.watson04
Member
17 Points
40 Posts
Mar 28, 2012 04:00 PM|LINK
I'm wondering if it's possible to Read an XML file - specifically an RSS feed - and a datasource and sort them by date or a field. I'm thinking about using a datareader but I'm not sure of how to mix the two sources, sort them and display them.
244 Points
52 Posts
Mar 28, 2012 04:58 PM|LINK
you can first convert xml to datatable:
Dim ds As DataSet Dim table1 As DataTable ds = New DataSet ds.ReadXml("Result.xml") table1 = ds.Tables("Customers")
then merge your datasource table and proceed further.
jlarremore
Member
17 Points
40 Posts
Mixing Database and XML, sorting and displaying
Mar 28, 2012 04:00 PM|LINK
I'm wondering if it's possible to Read an XML file - specifically an RSS feed - and a datasource and sort them by date or a field. I'm thinking about using a datareader but I'm not sure of how to mix the two sources, sort them and display them.
steve.watson...
Member
244 Points
52 Posts
Re: Mixing Database and XML, sorting and displaying
Mar 28, 2012 04:58 PM|LINK
you can first convert xml to datatable:
Dim ds As DataSet
Dim table1 As DataTable
ds = New DataSet
ds.ReadXml("Result.xml")
table1 = ds.Tables("Customers")
then merge your datasource table and proceed further.