Matt Berseth

Bookmarked!

This is technical ques, can you group it by date? I mean, just like how your blog archives were group by Month then by Year like so,

January 2008
December 2007
...

I can't do it using the OrderDate then by Total Orders :(

More Power to Matt!

Should I give you an easier way.

Use the AjaxControlToolkit accordion control and stick the grid into the template.

And what you get is a grid shown at a time. And if you want to see another grid the first one closes. So you use the maximum real estate of the page.

Nicely done! I like this.

Great article as usual!

Deepak, You cannot dynamically populate an accordion control's panes then bind a gridview to that pane.
Let me know if you have tried it.
Nice article Matt.

Hey Now Matt,
Great post, very informative & useful. The end result for the gridview functionality is really nice to have.
Thx 4 the info,
Catto

Does LinqDataSource allow to limit queries?

Thanks in advance

Looks great, but its running quite slow when paging? or its just me?

Cheers

thank you for the article

You also can't forget about the GroupTemplate. I can't tell if all of this could be done using it, but it's a useful feature anyway..

Great article.I really like your documantion style.It's very clean.Thanks for sharing your knowledge with us..

Hi PEN,
I tried to put the code in here but its just not showing correctly here. ie only part of the code is getting pasted. But I will try to point out the important features.

Code Page
1) Add an accordion control to the page. which supports OnItemDataBound="AccordionDisplay_ItemDataBound"
2) In the Content template add a grid with ID="grdDetails"

In the code behind
1) Somewhere you will bind the data to the accordion control
AccordionDisplay.DataSource = _SomeCollection;
AccordionDisplay.DataBind();

This will instigate a call to the following procedure

2) you will implement AccordionDisplay_ItemDataBound(object sender, AjaxControlToolkit.AccordionItemEventArgs e)

This gets called for each header and template

if (e.ItemType == AjaxControlToolkit.AccordionItemType.Content)
{
GridView grdDetails = (GridView) e.AccordionItem.FindControl("grdDetails");

// Once you got the grid bind it to your data source.

grdDetails.DataSource = _SomeData;
grdDetails.DataBind();
)

Hope this helps. I will keep a check on this blog for any more questions you might have.

It sure would be cool if you could do a tutorial on how to make a grid like the one from the extjs.com framework. They have the ability to click on the column header and then choose which columns you want to show in the grid. You can show/hide columns - I can't find anything like it on the web for asp.net and I don't want to use the extjs framework.

Awesome post. Makes me wish we were using 3.5 for my current project. Thanks a heap for this

You should by default set the row to visible and on load add the css class 'hidden' with javascript. In this way your page shows up nicely in browsers which don't support javascript or have it disabled. And you'll add some extra functionality for browsers that do support javascript.

Cheers,
Wes

wonderfully written article as it is so well explained, however unless I am missing a key point the LinqdataSource is a great RAD tool but useless for the n-Tier apps that most of use write.

Matt RULEZ!!!

Great article!

I was wondering how can I display the CustomerName instead of the CustomerId?

What would be the value of my Select= ?

Thanks!

I have changed the row content in the second listview "lvItems" with "linkbuton" controls, and now I would like to get the values of each cellule in the row when I click on this row
I've tried that by using ;

void lvv_SelectedIndexChanging(Object sender, ListViewSelectEventArgs e)
{
using (ListViewDataItem listViewDataItem = (ListViewDataItem)lv.Items[e.NewSelectedIndex])
{
if (listViewDataItem != null)
{
ListView lvv = (ListView)listViewDataItem.FindControl("lvItems");
ListViewItem item1 = (ListViewItem)lvv.Items[e.NewSelectedIndex];
LinkButton l1 = (LinkButton)item1.FindControl("LinkButton1");
Message.Text = l1.Text;
}
}
}

and;

asp:ListView ID="lvItems" runat="server"
DataSource=''
OnSelectedIndexChanging="lvv_SelectedIndexChanging" >"

thanks for your help

Awesome site and contributions as usual.

I'm trying to implement a nested ListView. I'm having a problem determing which ListView method in which to databind the nested ListView. I've been going through the MSDN ListView Members documentation and seem close but not quite there.

Here is my relevant ASPX code:

<asp:ListView ID="lvCartonsPackages" runat="server" ItemPlaceholderID="ipCarton" 
			  OnItemDataBound="lvCartonsPackages_ItemDataBound">
	<LayoutTemplate>
		<table class="yui-datatable-theme">
			<thead>
				<tr>
					<th>Tracking #</th>
					<th>Received</th>
					<th>Number Pkgs</th>
					<th>Expected On</th>
					<th>Carton Receipt Conditions</th>
				</tr>
			</thead>
			<tbody id="ipCarton" runat="server"></tbody>
		</table>
	</LayoutTemplate>
	<ItemTemplate>
		<tr>
			<td><%# Eval("in_track_num")%></td>
			<td><%# Eval("receive_date")%></td>
			<td><%# Eval("exp_num_packages")%></td>
			<td><%# Eval("exp_receive_date")%></td>
			<asp:ListView ID="lvCartonConditions" runat="server" 
						  ItemPlaceholderID="ipCartonConditions" 
						  DataKeyNames="condition_type_cde">
				<LayoutTemplate>
					<td id="ipCartonConditions" runat="server" />
				</LayoutTemplate>
				<ItemTemplate>
					<td><%# Eval("condition_type") %></td>
				</ItemTemplate>
			</asp:ListView>
		</tr>
	</ItemTemplate>
</asp:ListView>

And here is my relevant C# codebehind:

protected void lvCartonsPackages_ItemDataBound(object sender, ListViewItemEventArgs e)
{
	if (e.Item.ItemType == ListViewItemType.DataItem)
	{
		ListViewDataItem currentItem = (ListViewDataItem)e.Item;

		///NCA 27-Feb-08: Internal framework getting user object.

		string sUsername = Page.User.Identity.Name;

		Foo.User oUser = (Foo.User)Cache[sUsername];

		BOTypes oTypes = new BOTypes(oUser);

		

		///NCA 27-Feb-08: Basic two column result set here...

		DataTable dtCartonConditionTypes = oTypes.GetAllConditionTypes();

		ListView lvCartonConditions = (ListView)currentItem.FindControl("lvCartonConditions");

		lvCartonConditions.DataSource = dtCartonConditionTypes;

		lvCartonConditions.DataBind();

	}

}

Any direction would be greatly appreciated, meanwhile it's back to MSDN. Thanks again for the contributions here!

Clay

Should mention that I realize ItemDataBound isn't the place to do this, just used to test syntax.

Excellent Post Thank you

However paging causes the following error
Sys.WebForms.PageRequestManagerServerErrorException

This occurs with SQL 2000
SQL Express works fine. I have searched for a workaround.

Very nice code, thanks.
Is there a way to nest 3 ListView controls in order to group by yet another property, for instance the month of the order?

I can see where the results are pointed to the itemplaceholder of the listview; however, I am not sure how the nested list view places its results right under the its corresponding parent result.

In other words since there is only one how are the second batch of results placed right under its parent ?

Where is the second placeholder?

Thanks
Erik

Hi. I am playing with your code and using two tables to get data. In one table I have CategoryId and in second CategoryName. Normally with linq I would use
Eval("Table2.CategoryName") to show CategoryName in a listview
but in nested ListView it does not work, probably because the nested ListView's datasource is DataSource=Eval("Items").
I can use a function to make it work but in Linq there should be a direct way for this.
Any idea how to get CategoryName?
Thanks
Raja

Hi Matt, i really liked this article.

Currently I'm trying to use an ObjectDataSource instead of a LinqDataSource but it doesn't have a "items" proprty that I can use in the nested listview datasource.

Do you have any suggestion or idea that i can further investigate?

Thank you?

What needs to be done in order to change the Group by order to Count instead of the customer?

Since Count is not part of the data context it does not allow me select as a field.

Any thoughts!

Thanks,

Awesome article

Hi, matt! How can I sort the nested table . For example ,When I click the "ID", it will sort by "ID". However, when I use the ,I got a warning message.
Eager for your reply, thank u.

Is it possible to do same this you did in the article using asp.net 2.0
Building a Grouping Grid with the ASP.NET 3.5 LinqDataSource and ListView Controls

Thank You
Prahlad

@prahlad : Yes, you could use a listview or repeater and use the itemdatabound event to inject javascript onclick events.

@matt : you could alter the html to use tbody tags and hide/show the tbody element which will hide the rows with it.

Hi

Your projects are great!

I Have a question how can I make this grid to load with expanded nodes?

Thanks in advance!