I am still working on getting this task resolved.
I have a SQL field named Cust_Data that stores either one or multiple XML values. Here is an example: <Category>Fiction,Horror,Romance</Category>
I have an .aspx page where I need to display the values in the Category node:
<asp:CheckBoxList ID="cbGenres" runat="server" Text='<%# Bind("Genre") %>' DataSourceID="odsGenres" DataTextField="Category" DataValueField="Category"
AppendDataBoundItems = "true" AutoPostBack="true" />
<asp:SqlDataSource runat="server" ID="odsGenres"
ConnectionString="<%$ ConnectionStrings:LibraryMedia %>" ProviderName="<%$ ConnectionStrings:LibraryMedia%>"
SelectCommand="listGenres&q ...
Go to the complete details ...