what to use for display

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a formview that I need to display a listing of items in. This list is
related to the one record that the formview is displaying. So it is a one to
many issue. My question is what is the best way to display the data? It
would be in the ItemTemplate of the formview. It would also need to show in
the EditTemplate as well. Currently, the formview is working just like it
should be so only the display of the multiple is needed.
Thanks.
John
 
JohnE said:
I have a formview that I need to display a listing of items in. This list is
related to the one record that the formview is displaying. So it is a one to
many issue. My question is what is the best way to display the data? It
would be in the ItemTemplate of the formview. It would also need to show in
the EditTemplate as well. Currently, the formview is working just like it
should be so only the display of the multiple is needed.
Thanks.
John
Click to expand...

I started using a listview that is using a sqldatasource. I have gotten the
listview to work but it is showing all the application in the table. I hard
code a CR in and it shows what is there for it. The sqldatasource is below.
If a put in the WHERE the @cr a get an error indicating to 'declare the
variable @cr'.

<asp:SqlDataSource ID="ApplicationItemSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ProteusConnectionString %>"
SelectCommand="SELECT tblApplicationItem.ApplicationItem
FROM tblApplication
INNER JOIN tblApplicationItem ON
tblApplication.ApplicationItemID = tblApplicationItem.ApplicationItemID
INNER JOIN tblChangeRequest ON
tblApplication.ChangeRequestID = tblChangeRequest.ChangeRequestID
WHERE tblApplication.ChangeRequestID = @cr
ORDER BY
tblApplicationItem.ApplicationItem">
</asp:SqlDataSource>

My question now is how do I pass it from the gridview that is passing the cr
to the formview also to the listview?

Thanks...John
 
JohnE said:
I started using a listview that is using a sqldatasource. I have gotten the
listview to work but it is showing all the application in the table. I hard
code a CR in and it shows what is there for it. The sqldatasource is below.
If a put in the WHERE the @cr a get an error indicating to 'declare the
variable @cr'.

<asp:SqlDataSource ID="ApplicationItemSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ProteusConnectionString %>"
SelectCommand="SELECT tblApplicationItem.ApplicationItem
FROM tblApplication
INNER JOIN tblApplicationItem ON
tblApplication.ApplicationItemID = tblApplicationItem.ApplicationItemID
INNER JOIN tblChangeRequest ON
tblApplication.ChangeRequestID = tblChangeRequest.ChangeRequestID
WHERE tblApplication.ChangeRequestID = @cr
ORDER BY
tblApplicationItem.ApplicationItem">
</asp:SqlDataSource>

My question now is how do I pass it from the gridview that is passing the cr
to the formview also to the listview?

Thanks...John
Click to expand...

Thought I would give an update. I no longer get an error but I get no info
for the listview either. Sending the sqldatasource and what I have for the
source code of the listview. The listview is inside a formview that shows
the details of a record from a gridview. I get the correct data with
exception of the nested listview.

<th>Application:</th>
<td><asp:ListView ID="lvwItemApplications" runat="server"
DataSourceID="ApplicationItemSqlDataSource" DataKeyNames="ChangeRequestID" >
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceholder" runat="server" />
</LayoutTemplate>
<ItemTemplate>
<asp:Label ID="ItemApplicationsLabel" runat="server" Text='<%#
Eval("ApplicationItem") %>' />
</ItemTemplate>
</asp:ListView>


<asp:SqlDataSource ID="ApplicationItemSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ProteusConnectionString %>"
SelectCommand="SELECT tblApplicationItem.ApplicationItem,
tblApplication.ChangeRequestID
FROM tblApplication
INNER JOIN tblApplicationItem ON
tblApplication.ApplicationItemID = tblApplicationItem.ApplicationItemID
INNER JOIN tblChangeRequest ON
tblApplication.ChangeRequestID = tblChangeRequest.ChangeRequestID
WHERE tblApplication.ChangeRequestID = @ChangeRequestID
ORDER BY tblApplicationItem.ApplicationItem">

<SelectParameters>
<asp:QueryStringParameter Name="@ChangeRequestID" Type="Int32" />
</SelectParameters>

</asp:SqlDataSource>

I did have <asp:Parameter for the select parameter but that wasn't working
either.

I would like it if someone could look at this and see what I am missing.

Thanks.
John
 
JohnE said:
Thought I would give an update. I no longer get an error but I get no info
for the listview either. Sending the sqldatasource and what I have for the
source code of the listview. The listview is inside a formview that shows
the details of a record from a gridview. I get the correct data with
exception of the nested listview.

<th>Application:</th>
<td><asp:ListView ID="lvwItemApplications" runat="server"
DataSourceID="ApplicationItemSqlDataSource" DataKeyNames="ChangeRequestID" >
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceholder" runat="server" />
</LayoutTemplate>
<ItemTemplate>
<asp:Label ID="ItemApplicationsLabel" runat="server" Text='<%#
Eval("ApplicationItem") %>' />
</ItemTemplate>
</asp:ListView>


<asp:SqlDataSource ID="ApplicationItemSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ProteusConnectionString %>"
SelectCommand="SELECT tblApplicationItem.ApplicationItem,
tblApplication.ChangeRequestID
FROM tblApplication
INNER JOIN tblApplicationItem ON
tblApplication.ApplicationItemID = tblApplicationItem.ApplicationItemID
INNER JOIN tblChangeRequest ON
tblApplication.ChangeRequestID = tblChangeRequest.ChangeRequestID
WHERE tblApplication.ChangeRequestID = @ChangeRequestID
ORDER BY tblApplicationItem.ApplicationItem">

<SelectParameters>
<asp:QueryStringParameter Name="@ChangeRequestID" Type="Int32" />
</SelectParameters>

</asp:SqlDataSource>

I did have <asp:Parameter for the select parameter but that wasn't working
either.

I would like it if someone could look at this and see what I am missing.

Thanks.
John
Click to expand...

I finally got it figured out. No need to respond.
Thanks.
 
Back
Top