Forms Data Controls :: Using A Nested Listview To Display A Seperate Grid For Each Group Of Data Returned From Db Query
Jan 13, 2011
I am using a nested listview to display a seperate grid for each group of data returned from my db query. To get this working, I have adapted a piece of code to group the data prior to it being bound:
[Code]....
I am then using the following html markup:
[Code]....
[Code]....
This works as I want it to however some of the fields within the nested table need to be formatted as currency so I am trying to use Eval and {0:c} to do this however the moment I use Eval, the data items cannot be found
DataBinding: 'System.Data.DataRow' does not contain a property with the name '0'.
View 4 Replies
Similar Messages:
Aug 26, 2010
I am having trouble finding how to solve the following issue :
I am using nested listviews to display Sales and Sales details.
The main ListView displays General Information about Sales and the child ListView displays the detailed information about one sale. the child listview is shown only when the user clicks on a link (see included code, DataBind is made on PageLoad) :
ASPX Markup Code :
[Code]....
C# Behind Code :
[Code]....
If I removed the datapager part, I can manage show/hide the child list view on the button click event. but if I want to use the DataPager with the PreRender event handling, the child listview is not longer shown on button click.
View 8 Replies
Apr 26, 2010
I'm trying to use a ListView to display product specs. I also want to display the group headings such as "Dimensions", "Input Ports", etc.
How do I display these group headers? My code below lists the specs but doesn't show me the header. If I put some static text however, that shows up. What am I doing wrong?
[Code]....
View 4 Replies
Jan 2, 2010
HOW CAN I display image in list view and gridview while binding the data?
my picture is of image type in database and i want to get it from linq data source?
View 6 Replies
Mar 26, 2010
I'm using a linq group by query (with two grouping parameters) and would like to use the resulting data in a nested repeater.
var dateGroups = from row in data.AsEnumerable()
group row by new { StartDate = row["StartDate"], EndDate = row["EndDate"] };
"data" is a DataTable from an SqlDataAdapter-filled DataSet. "dateGroups" is used in the parent repeater, and I can access the group keys using Eval("key.StartDate") and Eval("key.EndDate").
Since dateGroups actually contains all the data rows grouped neatly by Start/End date, I'd like to access those rows to display the data in a child repeater. To what would I set the child repeater's DataSource? I have tried every expression in markup I could think of; I think the problem is that I'm trying to access an anonymous member (and I don't know how.) In case it doesn't turn out to be obvious, what would be the expression to access the elements in each iteration of the child repeater? Is there an expression that would let me set the DataSource in the markup, or will it have to be in the codebehind on some event in the parent repeater?
View 3 Replies
Jul 6, 2010
i need to get data-bound items from outer listview to display in inner Listview, in this scenario:
[code]....
Where the higlighted text mean the title for outer datasource.
View 3 Replies
Jan 16, 2011
i have one grid and one button when i click on that button then it expand and showing another grid under the row of parent grid how to do that.
View 2 Replies
Mar 13, 2011
I have anested ListView control. I also implemented a jQuery to automatically expand the TextBox control inside of the nested ListView Insert Template. The problem is, when the Textbox expand, the outer ListView control is not; therefore, the Textbox control expands underneath the buttons of the outer listView control. How do I expand the outer ListView control as the nested ListView textbox is automatically expand? One great example is in Facebook where if I add a response comment, it'll automatically push any comments below mine down. If nested Listview control is not the best way to do this, what are my options?
View 8 Replies
Aug 17, 2010
Ok, background first:
The form allows a user to create and edit one estimate.
Each estimate can contain multiple Jobs, which are represented in a ListView.
Each Job can contain multiple Parts, which are contained in a ListView that sits in each item of the Jobs ListView.
A user can add and remove as many Jobs as they want.
A user can add and remove as many Parts to/from each Job as they want.
I have no issues adding to each of these, but I do have a problem removing a single part from a single job.
For a reference, here is one Job in the Jobs ListView on the form:
I want to make sure that no matter what a user does, the part of the form they are working on saves what they have. Removing a row from that Parts ListView is no exception. What I want it to do is save the values in each of those textboxes and then delete the necessary row.
Here's what I have in the codebehind:
[Code]....
The EstimateRow variable I create does not get a value from theListView)HFERID.Parent.FindControl("LVEstimateRow") bit of code. There must be another level of nesting that I'm not accessing correctly, because it can't seem to find that nested ListView.
View 5 Replies
Feb 8, 2010
I'm attempting to further reduce a dataset/table by various user input. Part of this process is grouping the data by a timestamp prior to a summation. I'm trying to use LINQ and cannot get the data returned that I need.
[Code]....
View 7 Replies
Oct 19, 2010
I am using devexpress grid view. i have enabled SHOW GROUP PANELData is binded to the gridview using datatable in cs page . But when i drag the coloum to the header to group ...the grid show no data...
View 3 Replies
Dec 21, 2010
I have a listview control on the page.. when the page binds and the listview is presented, there should be only 6 records.. well those 6 are displayed corrected at the top, but then below that is the same 6 records.. and below that is the same 6 records.. this goes on 6 times for the page.
If only 1 record is returned by the query. the page lays out ok and functions as expected.. is there a configuration i need to make to the listview to prevent it from repeating itself the number of records it returns?
View 15 Replies
Nov 24, 2010
My requirement is i want to bind data to gridview2 which is placed in gridview1..Iam using EDM objects to refer database...So for Gridview1 Iam getting out put...now how to bind to gridview2...For gridview1 I binded the data which is in onetable...And for gridview2 i want to bind MENU table data...so how can i bind the data...
this is the gridview2..in gridview1 row.
[Code]....
I also tried using FindControl() but iam not able to proceed further.
View 1 Replies
Mar 11, 2011
How do display a list of data returned from the database like this.
[code]....
View 1 Replies
Aug 13, 2010
I have a gridview and would like to display one of 5 icons depending on the value returned from the database for that row (simply just A, B, C, D or E). Which event in my datagrid should I be looking at to check what value I'm getting? I presume once I can check a value I can simply set an image source using if statements?
View 4 Replies
Jan 11, 2010
I ran into this kind of situation many times without a nice solution. Binding a data source to a gridview and one of the column require nested query. Is it possible to have a callback function other than Eval()?
something like CallbackFunc(Eval("SomeField"));
View 2 Replies
May 25, 2010
I'm try to create a nested listview with the following display:
Category 1
--Board 1
--Board 2
Category 2
--Board 1
--Board 2
--Board 3
Here is my code so far:
[Code]....
The Data is from a SQL Data Source:
[Code]....
However I'm not sure what to set the inner listview's DataSourceID to as I need to display just the boards in that category.
View 3 Replies
May 24, 2010
I am trying to get my Nested ListView to work. I have my parent List View supplying the correct information, but I can't seem to set the SelectParameter Value for my Nested ListView. I am using SQLDataSources for both. I read your comment about adding a Hidden Field. Where Should that field be located. Right now I have it inside my Parent ItemTemplate but nothing is happening. Currently I have both DataSource outside my Parent ListView. I tried moved the nested ds inside with the list view but I still was not able to grab the hidden field values either. Here's what I have:
<asp:ListView
ID="lv"
runat="server"
DataSourceID="sdsParent"
DataKeyNames="CaseNo">
<LayoutTemplate>
<div
class="grid">
<h2>Bankruptcies
by RetailerID <asp:ImageButton
ID="btnSort"
runat="server"
ImageUrl="images/sort_asc.gif"
ImageAlign="AbsMiddle"
CommandName="Sort"/></h2>
<table
id="tblBankruptcy"
cellpadding="0"
cellspacing="0">
<tr
class="head">
<th
class="first"></th>
<th>Retailer
ID</th>
<th>Retailer
Name</th>
<th>Chapter
Number</th>
<th>District</th>
<%
--<th>Date</th>--%></tr>
<tr
id="itemPlaceholder"
runat="server"
/>
</table>
<table
id="pager"
cellpadding="0"
cellspacing="0">
<tr
class="pager">
<asp:DataPager
ID="pager"
runat="server"
PageSize="8">
<Fields>
<asp:TemplatePagerField
OnPagerCommand="PagerCommand">
<PagerTemplate>
<td
class="commands">
<asp:ImageButton
ID="btnFirst"
runat="server"
CommandName="First"
ImageUrl="images/first.gif"
AlternateText="First Page"
ToolTip="First Page"
/>
<asp:ImageButton
ID="btnPrevious"
runat="server"
CommandName="Previous"
ImageUrl="images/prev.gif"
AlternateText="Previous Page"
ToolTip="Previous Page"
/>
<asp:ImageButton
ID="btnNext"
runat="server"
CommandName="Next"
ImageUrl="images/next.gif"
AlternateText="Next Page"
ToolTip="Next Page"
/>
<asp:ImageButton
ID="btnLast"
runat="server"
CommandName="Last"
ImageUrl="images/last.gif"
AlternateText="Last Page"
ToolTip="Last Page"
/>
</td>
<td
class="info">
Page
<b>
<%
# Container.TotalRowCount > 0 ?
Math.Ceiling(((double)(Container.StartRowIndex + Container.MaximumRows)
/ Container.MaximumRows)) : 0 %></b>
of
<b>
<%
#
Math.Ceiling((double)Container.TotalRowCount / Container.MaximumRows)%></b>
(<%
# Container.TotalRowCount %> items)
</td>
</PagerTemplate>
</asp:TemplatePagerField>
</Fields>
</asp:DataPager>
</tr>
</table>
</div>
</LayoutTemplate>
<ItemTemplate>
<%
<%
-- <table id="orders" cellpadding="0" cellspacing="0">--%><tr
id="itemPlaceholder"
runat="server"
/>
-- </table>--%><tr
id="row"
runat="server"
class="group">
<th
class="first">
<img
src="images/plus.png"
alt='Group:
<%# Eval("CaseNo")%>'
onclick="toggleGroup(this, '<%# Eval("RetailerId") %>');"
/>
</th>
<th
colspan="1">
<%
# Eval("RetailerId")%>
</th>
<th>
<%
# Eval("RetailerName")%></th>
<th>
<%
# Eval("BankruptcyTypeID")%>Chaper 11</th>
<th>
<%
# Eval("DistrictID")%>District</th>
</tr>
</ItemTemplate>
<SelectedItemTemplate>
<asp:ListView
ID="lvItems"
runat="server"
DataSourceID="sdsChild">
<LayoutTemplate>
<tr
runat="server"
id="itemPlaceholder"
/>
</LayoutTemplate>
<ItemTemplate>
<tr
class="item">
<th></th>
<th>Action</th>
<th>Comments</th>
<th>Attorney
Information</th>
<th>Date</th>
</tr>
<tr
id="row"
runat="server"
class="item">
<td
class="first"></td>
<td><%#
Eval("ActionID")%></td>
<td><%#
Eval("CaseNo")%></td>
<td><%#
Eval("Comments")%></td>
<td><%#
Eval("AssigneId") %></td>
<td><%#
Eval("Date",
"{0:MM/dd/yyyy}")%></td>
<td><%#
Eval("CaseNo") %></td>
</tr>
</ItemTemplate>
</asp:ListView>
</SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource
ID="sdsParent"
runat="server"
ConnectionString="<%$ ConnectionStrings:Legal %>"
SelectCommand="SELECT * FROM [tblBankruptcy ]">
</asp:SqlDataSource>
<asp:SqlDataSource
ID="sdsChild"
runat="server"
ConnectionString="<%$ ConnectionStrings:Legal %>"
SelectCommand="select * from tblbankruptcyaction where CaseNo = @CaseNo">
<SelectParameters>
<asp:ControlParameter
ControlID="hf1"
Name="CaseNo"/>
</SelectParameters>
</asp:SqlDataSource>
View 2 Replies
Aug 8, 2010
I have two listviews. What i want to do is that when the nested listview emptydatatemplate shows i want to put a hyperlink with a querystring in it, the id in the querystring should be the fk in the nested listview. Is it possible to bind the hyperlink with the id in codebehind? I use two object datasources. Does it matter where i put the nested listview now i have it in the parents itemtemplate. Also it seems to be a problem to set the datakeynames in the nested listview, what could be the reaso for that.
[Code]....
View 3 Replies
Dec 9, 2010
I wanted to have 03 grid view nested in one another and to be able to perform
Insert
Update
Delete
on each of the grid view. Is it possible in Asp.Net.
View 2 Replies
Jan 13, 2011
I have a nested listview that I want to select the DataItem with a LinkButton or firing the ListViewSelectEventArgs, but I can't. I try the LinkButton with the sender object but a get null for the LinkButton when the OnClick event is fire and also try the ListViewSelectEventArgs to get the DataItem and again a get null for the object.
[Code]....
View 7 Replies
May 27, 2010
I'm trying the following code to access the value of a ListBox nested in a ListView.
View 3 Replies
Mar 16, 2011
have a nested listviews:
Listview1-Item1
<if Listview1.selected index = 0>
Item1NestedListView - item1
Item1NestedListView - item2
When a user selects an item in the parent listview, the nested listiview displays as part of the selected item template - when a user selects an item in a nested listview it correctly populates a third, separate listview. To make sure I'm being clear, I have a parent listview with many rows and each of those rows has a nested listview, that is only populated and displayed when the row is selected. The parameters for the nested listview are set in the ItemDatabound event of the parent.
I had this working fine when both objectdatasources were on the aspx page. However, requirements have changed and we would like to pass a class to the BLL. I cannot figure out how to do this using a datasource on the aspx page. I can pass a class doing a databind in the code behind. However, if I do the databind in the code behind, the SelectedItem template does not get displayed as I would like. I need to find the the selectedIndex for the parent listview in SelectedIndexChanging. however, when I click or 'select' an item in the parent listview, the page refreshes, the ItemDatabound of the parent of the parent fires NOT knowing the selectedindex, then the SelectedIndexChanging event fires changing the SelectedIndex. By this time the Listview is already on the screen without the selectedItemTemplate containing the nested listview. If I click on another item, the when the page refreshes it knows the selectedItemIndex chosen before and displays that SelectedItemTemplate containing the selected index.
View 3 Replies
Nov 5, 2010
what i want to apply paging on each list view "lvProducts" with in repeater "rptBrands";
in other words ;
i have several Brands and each one of them contains some products;
so i want to apply paging on each products group within their brand
so if you check the code below you find that it apply paging in good manner;
the problem is that if i select page 2 on the second brand group it will display page 2 for brand 2 and all brands group which is not needed ;
so how can i apply paging??
<div id="HomeContainer">
<asp:Repeater runat="server" ID="rptBrands" >
<ItemTemplate>
<asp:HiddenField ID="hfBrandId" runat="server" Value='<%#Eval("BrandId") %>' />
<div>
[Code]....
View 1 Replies
Jan 10, 2011
I have two listviews. The inner listview (InnerListView1) is in the SelecttItemTemplate of the outer listview (OuterListView1). Both listviews are bind in the code behind. The outer listview displays correctly in the ItemTemplate. Neither Listview Listview displays in the SelectItemTemplate. Both should display when I click the Select button. I just get a postback (flicker). The display should include the selected record of the outer listview and the inner listview.
Shown be low are code snipets of the.
Markup:
<asp:ListView ID="OuterListView1" DataKeyNames="entryid" runat="server" EnableViewState="False" EnableModelValidation="True" InsertItemPosition="LastItem" OnItemDataBound="OuterListView1_ItemDataBound" OnSelectedIndexChanging="OuterListView1_OnSelectedIndexChanging"
>
[Code]....
View 5 Replies
