Hi, I have a database field that stores multiple letters and numbers separated by ,
An example of this: o,t,g,h,w,x,q,l,m,b,c,5,r,
Each letter or number can be referenced to another table in the database which includes an explanation of what each letter or number actually means! The trouble I have is that I do not know where to start in order to display the correct results.
Can anyone help with some code to kickstart me in the right direction? I have the code below and this allows me to display the data from the field.
<asp:DetailsView ID="DetailsView1" runat="server" DataSourceID="SqlDataSource9" Height="50px" Width="125px" onpageindexchanging="DetailsView1_PageIndexChanging"></asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource9" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [field8] FROM [datafeed$] WHERE ([field1] = @field1)">
<SelectParameters><asp:ControlParameter ControlID="DropDownList4" Name="field1" PropertyName="SelectedValue" Type="String" /></SelectParameters></asp:SqlDataSource>
From the above example code each letter and
View Complete Post