environment: VWD 2010 Express, VB, SQL 2008 Express, .NET 4.0
Hello - I need some help understanding what's going on with my SQL. I have a listview that pulls data from a Tasks table. Inside the listview cells is a TaskID (among other stuff). That TaskID exists in a CrossRef table 0 or more times. The CrossRef table includes Task1 (TaskID), Sequence, Task2 (TaskID), Active, and XRefID. So Tasks.TaskID could possibly be used as CrossRef.Task1 or CrossRef.Task2 but not both in the same row. (that all works fine)
In my listview I display the text "XRef" if that particular taskID exists anywhere in the CrossRef table - that also works fine. What I would like to do is display the cross reference information when XRef is hovered over. I can get the entire table to come back as a hover but cannot seem to isolate the results to only the rows that match the TaskID.
I have tried this for my SqlDataSource:
<asp:SqlDataSource ID="SqlXRef" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT T1.Responsible, T1.Task AS Task1, C.Sequence, T2.Responsible AS Responsible2, T2.Task AS Task2
FROM CrossRef C
INNER JOIN Tasks T1
View Complete Post