Display XML from SQL SERVER
I have a table in SQL Server which I uploaded an entire xml file into. The table has 2 columns, Col001, Col002. Col001 holds all the xml text. Each row has one line of the xml file uploaded . Col002 holds the titles of sections contained in the xml, if no title is in the line of xml then a <NULL> is placed in Col002.
I am looking for a way to extract all the xml lines in between titles to display in an ASP.NET webform. For instance, if a title is located in Col002 then it should gather all info up to, but not including, the next title and output that information to the browser through ASP.NET. Does anyone know of a good tutorial that relates to this subject. Maybe I should post this on the ASP.NET forum. Any help will be appreciated. Thank you all.