SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Mohamed Yehia - If you stop Reading, you stop Leading — Mon, 26 Feb 2007 12:13:22 GMT

Paul Robinson has posted an interesting article about using SPGridView control to view custom data. ...

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

st3ph3n — Wed, 28 Feb 2007 13:58:49 GMT

Excellent article Paul. Can't wait for the next part.

Using a SPGridView inside an ASP.net Ajax UpdatePanel

Share This Point — Thu, 01 Mar 2007 03:45:10 GMT

Using a SPGridView inside an ASP.net Ajax UpdatePanel

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

fishwack — Thu, 01 Mar 2007 03:55:53 GMT

Hey thanks for the info about how to do sorting and adding the menus. Works great and me some time :D Just a note if you do the paging, in Jasons post, you have to also set the SortExpression in your Paging event handler.

I just put up a new post on using the SPGridView in an ajax updatepanel to do paging and sorting ajax style. Pretty cool stuff.

http://blogs.msdn.com/powlo/archive/2007/02/25/displaying-custom-data-through-sharepoint-lists-using-spgridview-and-spmenufield.aspx

-Mark

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Thu, 01 Mar 2007 20:46:15 GMT

That sounds great Mark, can you post the URL - I notice you've had a clipboard accident!

Glad people found this helpful - I'm gathering information on filtering etc for the next post.

Paul

WSS FAQ - additions and corrections - XXXXIV 26thFebruary - 4th March 2007

Mike Walsh's WSS and more — Sun, 04 Mar 2007 10:52:25 GMT

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

hardeep — Tue, 06 Mar 2007 19:39:34 GMT

This is Great!

I tried your sample but the drop down menu is not showing up. It shows the down arrow and the link on the list item itself is working but not the drop down menu. Any tips/fixes?

Thanks,

Hardeep.

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Wed, 07 Mar 2007 19:37:00 GMT

Umm, sounds interesting. Why not drop me an email with your code - there's an email link at the top.

Any chance you've figured out the third "sexy" option?

mdo77 — Tue, 13 Mar 2007 22:12:33 GMT

"We might have a third option to do a sexy postback to an event in the code behind, but I can't decipher exactly how to use that yet - keep tuned."

Paul:

Any developments here? It would make my job 1000% easier if this were to work. I've got to make some web service calls depending on what option is selected in the dropdown and it would be a great deal easier if I could do it in the web part class itself during pre-render.

Thanks,

Mike

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

mdo77 — Tue, 13 Mar 2007 22:19:45 GMT

of course, I meant Pawlo above, not paul. My apologies.

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Wed, 14 Mar 2007 08:18:23 GMT

Hello everyone,

Thanks for the comments. I'm on residential training in Redmond for a couple of weeks, which is consuming all my time. I will answer your comments as soon as I can, probably next week when I'm back in the UK. Please post any solutions if you get things working in the meantime.

I'm committed to taking this forward, and I'm now working with a very helpful contact in the WSS documentation team to find answers to the various bits and bobs.

Paul

Sharepoint 2007 Development with Datagrid and Dataset

Biztalk + Sharepoint = stefan @ decatec — Fri, 23 Mar 2007 18:41:17 GMT

SPGridView and SPMenuField example

Jason Wang's SharePoint Blog — Tue, 03 Apr 2007 22:37:35 GMT

Good article shows how to use SPGridView and SPMenuField. However seems SPMenuField still cannot help

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

groovyponens — Thu, 05 Apr 2007 10:54:25 GMT

Hello,

first at all, congratulations for the article. I have been following it in a custom web part.

I have a big doubt about SPGrid, i wish someone could help me. I don't know how to do to show a Linked Name to details page in the grid. I have tested with LinkTitle, LinkTitleNoMenu, . All of these fields return me the title of the element but not a link to details page as i want. ¿Do you know how have i to do it?

Thanks, very much,

Raul

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Thu, 05 Apr 2007 21:49:17 GMT

Raul,

I'm not entirely sure what you're trying to do. You're in full control over the SPGridView, so if you want your items to have a details page behind them, you'd need to code this in. Why not drop me an email (use the email link at the top) with more info.

Powlo

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

dmetge — Tue, 17 Apr 2007 21:06:49 GMT

Hi... great post !

But I've got the same problem Hardeep already mentionned : the drop down menu is not appearing (but the down arrow of the menu appears on the items of the list). Hardeep, did you finally solve the problem ? Or Paul, did you find a solution or an idea about it ?

Thanks in advance

dmetge

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Skullcrusher — Tue, 17 Apr 2007 22:47:56 GMT

Hi Paul great article, certainly saved me some time.

I have a couple of questions that you might be able to help me with.

1) Is there an easy way to have the groups collapsed when first rendered?

2) Can you have multiple level grouping? I know this should be possible as with lists you can create views that allow 2 levels of grouping.

Any insights would be appreciated.

Thanks

Andy

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Wed, 18 Apr 2007 11:15:41 GMT

Hi Andy,

I don't know of a way of showing the grid with the groups already collapsed and I'm not sure about the two levels of grouping either. Looking at how the fields/grouping parameters are passed I can't see how this would be achieved. Let me have a hunt around.

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Wed, 18 Apr 2007 11:18:41 GMT

Demetge,

When Hardeep sent me the code my was using it was pretty complex, as he had already extended the example with his own business logic. My advice, which I think worked, was to comment most of it out (!) until he got back to simple code, then check each property I was setting in the example was also set by his code - I'm pretty confident it will work if everything's in the right order!

Paul

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Skullcrusher — Fri, 20 Apr 2007 04:15:09 GMT

Hi Paul

I've managed to figure out a way to collapse the groups when first rendered, through some javascript that I'm registering with the page from within my webpart, I'll blog it next week.

As for the multiple grouping levels I'm still trying to fathom that one out 8-}

Andy

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

jay.arvin.s.gamiao — Fri, 20 Apr 2007 06:26:01 GMT

Nice blog! I do have one question though. Have you tried adding webcontrols in the SPGridView just like the GridView in ASP.Net. Like for example, I would like to have a Checkbox, Image and a linkbutton and when you click on the linkbutton, it would open the item and execute a stored procedure?

Jay Arvin

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

c05lc31 — Fri, 27 Apr 2007 07:01:04 GMT

Its great article. I am need to sharepoint and wanted to find out if you have the code as to What TVData looks like

Thanks

Deep

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

dmetge — Thu, 10 May 2007 17:18:22 GMT

Hi Paul,

Sorry I'm back with the same problem again (the problem Hardeep already mentionned too) : I've made a webpart using exactly your code this time, but again it doesn't work : the SPGried is appearing and the down arrow of the menu is appearing on each item, but the drop down menu never appears when I click the arrow.

As I'm sure now it can't be a problem in the code, could it be a contextual problem ? I mean, something else on the page (or the site) preventing the menu's script to work ?

Did you or someone already heard about it ?

I've simply created a collection and a site, and put my webpart on the first page of the site. Furthermore there is no other webpart on the page. I don't know what I could try now. Voodoo things ?!

Thanks in advance !

dmetge

Filtering with SPGridView

Bob's SharePoint Bonanza — Mon, 14 May 2007 10:49:33 GMT

I recently chose to use this control in a scenario where filtering using the UI was required. I had heard about the SPGridView and knew it had the filtering capabilities I needed, but I had a very hard time figuring out how to use it. But after much (unsuccessful)

Using SPGridView Filter properties

Powlo's SharePoint Treats — Tue, 15 May 2007 10:58:05 GMT

Great news everyone \o/ - a solution to setting an SPGridView filter has been researched and documented

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

hardeep — Tue, 29 May 2007 04:13:43 GMT

Powlo/dmetge,

Sorry for the late reply. I didn't visit this blog for a long time. Actually I got the drop downs working a while ago. The code was missing one thing: base.Render(writer); within the webpart Render method. I added that and it worked!!

Hardeep.

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

ArjunaK — Sat, 09 Jun 2007 01:01:43 GMT

Thanks Powlo and Hardeep!

I was also having the same issue and base.RenderWebPart(writer) rendered the drop down menu nicely.

Arjuna

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

dmetge — Tue, 12 Jun 2007 17:58:49 GMT

Thanks a lot Hardeep,

indeed, a base.Render(writer) instruction is necessary at the end of the webpart's Render method if we want the items of the menu to appear !

But there is another solution, too ! Let me explain, it can maybe be useful for someone.

In fact, the base.Render(writer) calls the RenderControl() method for all the objects added in the createChildControls method (using this.Controls.Add)

In Powlo's script there, both the SPGridView oGrid and the menutemplate presenterListMenu are added to the controls of the webpart. So, when we call base.Render(writer) in the Render method, both oGrid.RenderControl(writer) and presenterListMenu.RenderControl(writer) are called !

So, if you can't call base.Render(writer), for example in case you have other controls that you don't want to appear at the same time, you just have to use :

oGrid.RenderControl(Writer);

presenterListMenu.RenderControl(writer);

in the Render() method of your webpart ! Of course, to do this you'll have to declare both oGrid and presenterListMenu as global properties in the script.

Then it will work fine, it's a very logical thing : the menu needs the menutemplate to work.

Hope it can help !

dmetge

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Tue, 12 Jun 2007 18:10:17 GMT

We're getting some great comments on here - thanks for the advice and community help people!

Powlo

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

kalle11 — Thu, 14 Jun 2007 15:21:07 GMT

I have made a webpart based on this code (plus some more functionality of my own, mostly for testing purposes) and everything works, except for the paging.

I can see the correct nr of records on page one and got the paging menu below and so on, but when I press the "2" to go to next page the page simply refreshes and I'm back at page "1" again, so I can never see the other pages of records. What can cause this problem?

I tried and commented out all the code associated with sorting thinking that might be causing some problems, but I still can't see any other pages than the first in the page list.

I'm new to webpart/asp programming so any help or suggestions would be greatly appreciated.

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

kalle11 — Thu, 14 Jun 2007 15:47:50 GMT

I just noticed that I posted my last post on the wrong page (should have been in the "part2 - paging article") but as I posted here before I continue to do it also.

Anyway, I tried another thing in my code and it solved my paging problems. It seems like it's working as it should now (haven'tested it thorougly yet though) so you can ignore my previous question.

The change I did was to move the code that added data to the datatable from it's previous place in the RenderControl method to the beginning of the CreateChildControls method (directly after the "new DataTable" statement.

It feels like there is something about theese two methods that I don't really understand, like exactly WHEN they are called and in what order. I thought that CreateChildControls was called the first time the webpart got initialized (like when loading the page where the webpart is located on, thus all the initializing of controls and so on) and that everything else after that regarding visible controls was handled by the RenderControl method. Apparently I was wrong but now I'm really confused.

So, can any kind person explain when the both methods is being used? I'm trying to get a bigger picture of webparts and how the common methods work, but imo it's hard to get a good picture of it all and MSDN isn't really helping out to be honest (they only go into details, not the bigger view that I need to understand how it all relates to eachother).

Thanks in advance.

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Fri, 15 Jun 2007 12:35:59 GMT

Hello,

Glad you got sorted. There's some simple info at

ASP.NET Web Parts Life Cycle

http://msdn2.microsoft.com/en-us/library/ms366536.aspx

but I guess you're already past that. I remember seeing a very complete version which shows which events fire in which order - a full page of flowcharts - I'll try and remember where it was and search it out for you.

Calling a postback event

cfarmerga — Fri, 15 Jun 2007 23:09:46 GMT

I thought I'd share the result of my effort to figure out the postback stuff. It seems to work well enough for me, and I'm just doing this in an application page instead of a webpart, so YMMV, but the effect should be the same.

I noticed (via Reflector) in the setter for MenuItemTemplate.ClientOnClickUsingPostBackEvent there was some code to parse parts of this string value, apparently delimited by commas. Teh first part evaluates to a control name. I thought this was weird, since I don't want to simulate clicking on another control. Then I noticed the special "__page" value that enables you to postback to the containing page. Perfect. So, I just implemented IPostBackEventHandler on my derived page class and implemented its single method:

void IPostBackEventHandler.RaisePostBackEvent(string eventArgument)

{

throw new Exception("WHEEEEEEE! " + eventArgument);

}

Then in my MenuItemTemplate, I set the ClientOnClickUsingPostBackEvent property's value to "__page,%NAME%". When I ran my page and clicked on my menu item, I got my nice error message with the resolved value of the %NAME% token for that list item.

The moral of the story is that without Reflector, this would have been miserable. As it was, it took about 45 minutes to figure this out. It sure would be nice to have some better docs for the lower-level stuff like this, though!

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

cfarmerga — Fri, 15 Jun 2007 23:11:21 GMT

Slight nit: Oops. I meant "application page" when I said "content page."

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

Paul Robinson — Fri, 15 Jun 2007 23:21:20 GMT

Thanks cfarmerga - sounds like you've got it all sewn up!

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

cfarmerga — Sat, 16 Jun 2007 00:54:29 GMT

While I'm here, I'd like to know what the best way would be to cause a postback on simply clicking the SPMenuField's item. I really want to use the menu field for the cool menu features, but I also want to have the default behavior of clicking the text of my item result in a postback.

Thanks!

How about DetailsView?

Petrander — Sun, 17 Jun 2007 00:00:16 GMT

Hey Paul,

Great article and just what I was looking for investigating the different possibilities of customizing the powerful SharePoint platform.

Interesting that there is a special SharePoint version of the GridView control so familiar to regular ASP.NET 2.0 users. One thing that I am missing, though, is an equivalent of the equally familiar DetailsView control.

Being pretty new to SP I may have overlooked something, but it would really be nice it were possible to display details of a row selected in a gridview on the same page.

re: Displaying custom data through SharePoint lists using SPGridView and SPMenuField

timo77 — Mon, 25 Jun 2007 16:25:08 GMT

I Paul,

grat article, it was very helfull for me, thanks.

You saved me a saturday night otherwise I've spent to think how implement a menu in a column grid :)

I've another question.

How about to implement the ToolBar menu where i can add my custom button and menubutton?

I've tried but it doesn't work.

thanks in advance.

the code for my toolbar:

[SharePointPermission(SecurityAction.InheritanceDemand, ObjectModel = true),

SharePointPermission(SecurityAction.LinkDemand, ObjectModel = true)

//, AspNetHostingPermission(SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)

//, AspNetHostingPermission(SecurityAction.LinkDemand, Level = AspNetHostingPermissionLevel.Minimal)

]

public class N41SPToolBar : TemplateBasedControl

{

[SharePointPermission(SecurityAction.Demand, ObjectModel = true)]

protected override void CreateChildControls()

{

base.CreateChildControls();

Microsoft.SharePoint.WebControls.ToolBar toolbarControl = (Microsoft.SharePoint.WebControls.ToolBar)this.TemplateContainer.FindControl("toolBarTbl");

//this.TemplateName = DefaultTemplateName;

this.Controls.Add(toolbarControl);

if (toolbarControl != null)

{

//Microsoft.SharePoint.SPCustomActionElement.AddCustomToolbarButtons(this.Web, base.RenderContext.List, null, Microsoft.SharePoint.PAGETYPE.PAGE_VIEW, toolbarControl);

this.TemplateControl = toolbarControl;

}

protected override string DefaultTemplateName

{

get

{

string toolbarTemplateName = string.Empty;

if (string.IsNullOrEmpty(toolbarTemplateName))

{

return "ViewToolBar";

}

return toolbarTemplateName;

}

the method in my webpart.

private void CreateToolBar()

{

N41SPToolBar toolbar = new N41SPToolBar();

toolbar.ID = "toolbarlist1";

this.Controls.Add(toolbar);

}

Filtering with SPGridView

bobsbonanza — Mon, 02 Jul 2007 14:36:02 GMT

I had heard about the SPGridView and knew it had the filtering capabilities I needed. I managed to get it right and thought it would be nice to share this information with others facing the same challenges I did.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

vipintanwar — Wed, 25 Jul 2007 21:28:32 GMT

Can we any number of groupings in the SPGridView Control ?

Actually , i need to make a web part which looks like this:

-Web application name1

-- Top level site

--- Subsite 1

--- Subsite 2

-- Top level site 1

--- Subsite 1

- Web application name 2

-- Top level site

--- Subsite 1

--- Subsite 2

-- Top level site 1

--- Subsite 1

i.e grouping on the basis of web application , top level site and subsite.

Can we use SPGridView for it or do we have any other control to make such a web part ?

or is there any out-of box webpart that can be customized for it ? ANY Idea.

Thanks,

Vipin

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

nnarvekar — Thu, 02 Aug 2007 22:31:50 GMT

Is it possible to have summaries for groups for totals. I am hoping they won't be sorted.

Thanks

Kalpana

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Paul Robinson — Thu, 02 Aug 2007 23:20:21 GMT

hi - I'm still trying to work out whether we can tap into the more advanced things like multiple goruping, counts etc but at the moment it's a no -- sorry

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Robin Sharepoint Blog — Wed, 08 Aug 2007 14:40:54 GMT

Blogged you at :

http://glorix.blogspot.com/2007/08/i-l-spgridview.html

Thanks alot!

I (L) SPGridView

Mirrored Blogs — Wed, 08 Aug 2007 15:00:34 GMT

Currently I'm busy with redeveloping some 'old' 2003 webparts and quite often I used a .NET

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

kasper@nathansen.dk — Sun, 12 Aug 2007 23:31:00 GMT

Thanks for a very good post. I can't figure out how to get the TVData to work. It tells me that I'm missing an reference in VS.NET - what do I do wrong?

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

robert321 — Tue, 21 Aug 2007 13:00:19 GMT

Am i missing something that makes the spgridview create links for example: created by columns etc?

I only get everything in normal text.

Second question is it possible to get the toolbar that are with lists in normal cases.

Any help is appreciated.

/Robert

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Robin Sharepoint Blog — Thu, 30 Aug 2007 23:07:24 GMT

For the ones who are looking to automically collapse all the grouping, check out my post http://glorix.blogspot.com/2007/08/spgridview-and-collapsed-grouping-by.html

It's, just like SkullCrusher said, a piece javascript that's been rendered after the grid has been rendered. I've gotta get it to work while using the Ajaxwebpart.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

ivan2007 — Wed, 05 Sep 2007 19:19:50 GMT

Hi,

First of all, thanks for this great article.

According to cfarmerga the Unfortunately I can't get the MenuItemTemplate.ClientOnClickUsingPostBackEvent is supposed to work.

Unfortunately I can't it at work.

My Webpart implements the IPostBackEventHandler.

I set the ClientOnClickUsingPostBackEvent property's value to "__page,%NAME%".

The problem is that my implemented RaisePostBackEvent method doesn't get fired. Can someone please help me?

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Iko — Thu, 13 Sep 2007 02:32:53 GMT

I read earlier that someone was looking for linking from grid items to a Details page. There is a simple way to do so: in the column definition you turn off the HtmlEncode property, and in the Data you add to the dataset, you can put an <a...nchor tag around the item. Optionally, you can also supply a Source parameter which returns to your current page after an edit operation... HTH

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Iko — Thu, 13 Sep 2007 09:27:38 GMT

This is an excellent post (original) and has helped me save a lot of time. I have a nice multi-site task list rollup web part working. Thanks much.

Now, I tried the same using the SPCalendarView - but for the life of it, I could not find a way to bind some of the columns in the dataset to the Calendar View. When you create a Calendar View for a Task List from within Sharepoint, you are required to specify Time Interval (Start and End) field names, as well as coresponding fields for Monthly View Title, Weekly View Title, Week View Subheading, etc.

I could not find any properties in the SPCalendarView class that looked like candidates for this kind of mapping. I did find a SPCalendarItem class, and the constructor had pretty much all data fields for a calendar item, but that would mean iterating and manually adding items. Defies the purpose of data binding...plus, I did not find a way of "feeding" the SPCalendarItemCollection to the view control either.

Has anyone looked into this yet? Any help is greatly appreciated.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Iko — Thu, 13 Sep 2007 22:31:35 GMT

Follow up on previous post: For the SPCalendarView, you actually populate the SPCalendarItemCollection and then use it as DataSource of the SPCalendarView object.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

mekrish — Fri, 21 Sep 2007 23:24:10 GMT

Thanks for the good post,

I am trying to bind the "Type" field of document libray to the SPGridview and my datasource is list(i.e document library). I tried to do as

HyperlinkField h1= new HyperlinkField();

h1.DataTextField="Item Type";

....

and i got only 1 and 0 on the type field. If the item is folder it shows 1 and if the item is document it shows 0. I want to show the folder icon and document icon in my SPGridview. can you please suggest me any idea..

krish

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

dmitryvy — Tue, 16 Oct 2007 13:56:57 GMT

Hi All!

Great article! Does anybody know how to add standard menus to the SPGridView?

Thanks a lot

SPGridView sorting when using a datasource

Aidan Garnish — Tue, 23 Oct 2007 12:47:19 GMT

SPGridView sorting when using a datasource

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

robin3000 — Fri, 02 Nov 2007 16:52:40 GMT

Excellent post. I have built upon your example for creating context sensitive menus based on this example, if anyone is interested. You can view the blog at http://robin3000.blogspot.com/2007/11/context-sensitive-menus-in-sharepoint.html

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

bazztrap — Mon, 24 Dec 2007 23:58:51 GMT

I encountered some issue with Grouping.

SPGRIDVIEw and Objectdatasource objects

I am implementing this in a web part along with a button to select different views on SPGridView (one of which is grouped view)

There are different columns for the both the views and 2 common columns which get displayed in both the view.

The Grid loads up fine with standard view on chnaging to view to Grouped.

The postback event looks for the new view and I call SPGridView bind

The Group view Displays fine.

But now I switch to other or the orignal view non grouped..

It displays the header correctly... the filter options show correctly but the datarows dont have any column which is new for this view and only shows the previous columns but the data is updated.

Note these functions work fine with out grouping..

The interesting thing is if I have 2 grouped views and I change from one to another it takes me to web part maintennace ... on SPGridView.DataBind() the stacktrace leads me to SpWeb object with index out of range exception (WIERD)

Also as i said binding was done in CreateChild and Postbackevnt.

After prerender the Ondatabind event was fired twice ( iguess for 2 times it was called) .. but after moving the view from grouped to non grouped it was fired just once.

I also moved the SPGrid.DataBind to Render Method and took it out from createchild and postback event .. it displayed all the view perfectly ok ... but then the header stoped displaying filter details .

Maybe I am mising somehting .. Anyway if not this I will just overirde SPgridEvent and manually display groups in old fashion way... this thing shouldnt be that difficult

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Paul Robinson — Fri, 28 Dec 2007 15:54:18 GMT

sounds a bit odd - did you get it sorted?

Link to the project missing

stephaneey — Sun, 30 Dec 2007 13:03:37 GMT

Hello,

Thanks for sharing this code but unfortunately, it doesn't work on my machine and I can't figure out why. The ECB is there but when clicking on the arrow, nothing happens although I made a copy/paste of your code.

Would it be possible to propose your project in download? or...do you have any idea of what's going on here?

Thanks anyway.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

bazztrap — Thu, 03 Jan 2008 20:06:26 GMT

Eh...

I think the problem has something to do with View state and binding between datasource and SPGridView... Something somewhere holds on to something or doesnt get updated..

I am now using 2 GridViews and 2 ObjectDatasource between different datasource.

When you have viewstate turned off .. on post back the Filtered Selection does not persist( as expected) But Sort does persist I think on object datasource .

all this makes me want to switch to EXtJs.2.0

sorting on two the same webpats on the same page

icop — Sat, 12 Jan 2008 23:30:17 GMT

Hello,

and thanks for helpful article. Anyone encountered the strange problem with sorting(and filtering) on identical webparts laid on one page with identical data? When you click link on a column's header on any webpart to sort that column the action is just right but when you do the same sorting from header column's menu sort action applied to a webpart that is a first on a page.

Any ideas?

Thanks in advance.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

stephaneey — Thu, 17 Jan 2008 17:24:27 GMT

Hello,

Just to let you know : the problem I had was because I implemented a custom render method in which I had MySpGridView.RenderControl(writer)....and that's why the menu was not working properly....

By the way, another interesting thing would be to know how to filter menu items. So for instance, enabling menu actions according to the data stored in the list item.

I found out how to impose a certain permission level by using the Permissions property but having a kind of conditional formatting on the menu items looks more difficult.

Any idea? (how to bind actions to content type for instance, handled by the standard via a feature...=> custom action+registration type combination.)

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

poni — Sun, 27 Jan 2008 14:05:39 GMT

I try to use SPGridView control inside my User Control in order to put it inside SP page. My data source is SP list.

When I put my user control inside regular aspx page (not under MOSS application), everything works fine.

When I put the same control inside page layout and create a page based on this layout - spgridview does not show any rows. It calculates number of pages correctly. When I print oGrid.Rows.Count to some label on the same page, it shows the correct number of rows. So - why these rows do not appear ? Any help ??? Any ideas ??? Thanks.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

mayur.joshi — Wed, 27 Feb 2008 12:22:18 GMT

HI stephaneey,

Even i am looking out for a solution to the business problem like you have. Do you have any leads for the same...

Customizing SharePoint 2007 Search Result for Structured Content

Everything Microsoft. — Fri, 04 Apr 2008 22:06:41 GMT

The out of the box Search Core Result web part displays search result in a format that is best suited

Using PostBack on SPGridView and SPMe...

Welcome to Jason Huh's blog — Sun, 06 Apr 2008 22:56:40 GMT

Using PostBack on SPGridView and SPMe...

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

shiva_kalluri — Mon, 19 May 2008 11:51:52 GMT

Hi,

In my application I'm using SPGridView, but Ineed multi level grouping.

Could you please tell me how to do the multi level grouping.

Thanks in advance.

Shiva

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Paul Robinson — Mon, 19 May 2008 12:19:16 GMT

Unfortunately I haven't found a way to do this yet :(

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Pankaj76 — Wed, 04 Jun 2008 23:16:04 GMT

Hi Paul,

It was a great posting and saving my time.

I have a requirement to give the ClientOnClickNavigateUrl' on the 'GroupField' and 'GroupDescriptionField'.

I couldn't find any posting to help me on this.

Regards,

Pankaj

re: SPGridView Grouping and Sorting

Hari2008 — Wed, 11 Jun 2008 08:26:52 GMT

Hi,

I have enabled Grouping and sorting in SPGridView in my web part.

I need to sort the items within the Grouped values but for me grouping is done on sorted values.

Anyone pls help me.

Regards,

Thiru

Hi

Yanet — Fri, 27 Jun 2008 03:02:55 GMT

Hi Paul, excelent post !!!

I develop a webpart using SPGridView and SPMenuField like you, and all is rigth, very functional. I use the DataTable component as the source of my GridView but I have a problem: When I specify myMenu.NavigateUrlFields = "ID", an error is displayed: "Field not found: ID". The field ID is contained in the DataTable´s fields...

I have tried to find a solution but the problem persists..

I need some help....

Thanks...

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Paul Robinson — Fri, 27 Jun 2008 11:35:58 GMT

Hi there. Have you got any code you can let me have a look at? It doesn’t need to build or anything – just the .cs. Use the Email link on the top toolbar to get in touch.

Hi Paul!!

Yanet — Sat, 28 Jun 2008 20:01:12 GMT

Hi Paul, I sent you an message using the Email link as you said me. I hope you can help me, I need it so much..

Thanks...

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

levah — Wed, 02 Jul 2008 10:00:36 GMT

Hi there. I develop a webpart using SPGridView and I can add hyperlink column, with datasource in hyperlink column in SharePoint list. Problem is in SharePoint hyperlink column. This column type, return value in format "URL, URL Title" (for example "http://localhost, Intranet"), but this value isn't regular URL.

Anybody know, how to show SharePoint list hyperlink column, like hyperlink column in gridview?

Thanks

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Paul Robinson — Wed, 02 Jul 2008 10:55:11 GMT

could you try adding a template column and formatting the sharepoint field the way you want it, with <a> tags?

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

levah — Wed, 02 Jul 2008 12:25:18 GMT

Can you send me example?

Now I have tihs code:

BoundField column = new BoundField();

column.DataField = "URL";

column.HeaderText = "URL";

column.HtmlEncode = false;

column.DataFormatString = "<a href=\"{0}\">{0}</a>";

column.SortExpression = "URL";

this.oGrid.Columns.Add(column);

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

abradley — Tue, 19 Aug 2008 04:46:01 GMT

Great information. Have you had any experience using the SPGridView.AutoGenerateEditButton and the related RowUpdating functionality? I am trying to do this in my web part and the "Update" method never gets called. I think this is because in CreateChildControls I need to re-create my grid, but I am not sure how to get around this. Any pointers would be appreciated.

Not so happy error

JosephIM — Thu, 21 Aug 2008 20:49:02 GMT

Hey guys i am using a ascx to builtout all of my controls and sush for a webpart. What i am doing is allow users to dynamically seach for data in sharepoint via 2 dropdown boxes. all workign great. However...

When i add the SPMenuField to the GridView on post back it fails with:

"A control with the specified ID 'PropertyNameListMenu' could not be found within the scope of the current naming container. "

I cant get the sharepoint control elements to even be recognize in VS if i try to build the control directly into the ascx. which is just an added layer of frustration.

How can i get around this, its been 2 weeks i have been on this issue and i cant resolve it. At this point my code looks like a 5 year old wrote it from me trying every imaginable hack i could think of to get this working.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

jajalc@gmail.com — Tue, 26 Aug 2008 08:54:56 GMT

This is too good.. Thanks for this.. really appreciate your effort

Custom webpart vs. SharePoint Designer XSLT

Marco Bellinaso — Mon, 01 Sep 2008 21:40:57 GMT

Custom webpart vs. SharePoint Designer XSLT

Custom Actions Unleashed

.neting in the free world — Mon, 08 Sep 2008 00:27:56 GMT

If you would like to have some paragraphs translated from Polish to English please leave a comment. Post

SPGridView – sposób wykorzystania oraz ograniczenia

.neting in the free world — Wed, 24 Sep 2008 01:34:44 GMT

Nie raz już w różnych przypadkach podawałem wam linki odnoszące się do SPGridView , pora się temu trochę

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

el_topo — Mon, 22 Dec 2008 11:18:16 GMT

Great article.

Has anyone tried/succeded in selecting a row from the grid that is on the other page (so the application changes page index to proper one and selects proper row)? I wasn't able to get this working with all the paging/sorting/filtering in spgridview...

Could anyone post a solution for such case?

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Moonman — Thu, 25 Dec 2008 21:58:40 GMT

Great article but for the life of me I can't figure out what TVData is? I've read this article 160 times and can't figure it out...

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Paul Robinson — Mon, 29 Dec 2008 13:04:54 GMT

Sorry Moonman - not trying to confuse you! TVData is the name of a dataset I created in the Visual Studio designer which has a single Presenters table containing ID, PresenterName and ProgrammeName columns (as in the above image).

SharePoint - The New Oracle

Andreas Zenker — Thu, 08 Jan 2009 05:01:35 GMT

I was posting a WPF question on stackoverflow and I took a few minutes to tie up loose ends on a question

Adding menu items depending on the row

LUNAR — Sun, 11 Jan 2009 11:46:05 GMT

Hi Powlo

Its really a great post, :thumbs up:

Im adopting your approach now in my site, however im facing a minor issue (i hope its minor).

Lets say that i have two records in my dataset , each one has its own category (yet they are in the same dataset) , i bounded them to SPGrid , it worked fine , but i need to create a different actions in the menu for either.

MyDataRecord1 >> Action is Delete

MyDataRecord2 >> Action is Edite

can i populate SPMeue items depending on the data??

(i.e. can i build my own menu template ? )

Thanks in Advance and Keep Up The Brilliant work.

Problem with SPFieldMenu

dewing1984 — Mon, 09 Feb 2009 20:58:26 GMT

When I click on the SPField Item in the web part the ECB is not displayed ? I have a similar web part which seems to work all. Not sure why this one isnt working ?

I am not even sure how to debug this.

#region CreateEmailECB

SPMenuField coleMail = new SPMenuField();

coleMail.HeaderText = "E-Mail";

coleMail.ImageUrlFormat = "/_layouts/images/EML16.GIF";

coleMail.ToolTipFields = "E-mail";

coleMail.MenuTemplateId = "contactECBMenu";

coleMail.NavigateUrlFields = "E-mail";

coleMail.NavigateUrlFormat = "mailto:{0}";

coleMail.TokenNameAndValueFields = "EMAIL=E-mail";

MenuTemplate emailECB = new MenuTemplate();

emailECB.ID = "contactECBMenu";

MenuItemTemplate EmailMenu = new MenuItemTemplate("Click to Email"/*, "/_layouts/images/EML16.GIF"*/);

EmailMenu.ClientOnClickNavigateUrl = "mailto:%EMAIL%";

MenuItemTemplate copyEmailToClipBoardMenu = new MenuItemTemplate("Copy to Clipboard"/*, "/_layouts/images/COPY.GIF"*/);

copyEmailToClipBoardMenu.ClientOnClickScript = "CopyToClipBoard('%EMAIL%')";

emailECB.Controls.Add(EmailMenu);

emailECB.Controls.Add(copyEmailToClipBoardMenu);

coleMail.SortExpression = "E-Mail";

Controls.Add(emailECB);

summaryGridView.Columns.Add(coleMail);

#endregion CreateEmailECB

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

DarinBradford — Wed, 18 Feb 2009 21:11:21 GMT

I've used this example and love it, thanks. Now I'm trying to take it to the next level. I want this webpart to be a provider webpart that another webpart could consume. so when a slection is made,another webpart could show the details. I've struggled with this for several days. I was wondering if anyone had an example of anything close. A SPGridview provider webpart??

thanks in advance.

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

Moim — Fri, 06 Mar 2009 11:49:40 GMT

Nice work!!

Did you happen to know if I use the SPGridView, the columns do not display as a dropdown link with sorting options like asc/des and with some distinct values -what I can see in a usual SharePoint document library webpart column..? What exactly do I need to do for that?

How to work around bugs in the SPGridView control

Adventures in Consulting — Thu, 12 Mar 2009 03:48:54 GMT

SharePoint has a little known web control called SPGridView. This control can give you a SharePoint list-like

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

krishnet — Fri, 17 Apr 2009 21:21:41 GMT

Amazing work Paul. Sorting, grouping worked for me like described. What I wanted is to display # of child elements for each group. e.g.

Parent1 (3)<--- Number of elements in a group.

...Child1

...Child2

...Child3

Parent2 (2)

..Child1

..Child2

Any help is much appreciated.

Customizing SharePoint 2007 Search Result for Structured Content

Everything Microsoft. — Tue, 02 Jun 2009 21:49:53 GMT

The out of the box Search Core Result web part displays search result in a format that is best suited

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

GregJS — Mon, 08 Jun 2009 21:42:59 GMT

Hi Powlo,

Thanks for this great post. It was very helpful. I had something working in a very short amount of time.

I'm having one problem still though, and I'm wondering if you might be able to give me some advice.

I'm trying to use the technique described in this post to display task items from all the Task Lists in my whole site collection. I'm working on the links, and the problem I have is that for the NavigateURLFormat property, the url will be different depending on which task list the item is from. Providing an ID is not enough. I have to specify which Task List the item is from also.

Do you know how I might be able to get the url for each task item as part of the query I do(using SPSiteDataQuery), and then incorporate that info into the NavigateURLFormat in such a way that it's different for each item in the list? Or will I have to pass the url to some kind of redirector page?

Thanks,

Greg

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

pdmateus — Tue, 07 Jul 2009 13:47:23 GMT

When i enable grouping and then sort the rows i get weird groups... and some times the first group doesnt get the (+) expand...anyone is having this problem?

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

michael8 — Wed, 08 Jul 2009 13:20:58 GMT

Hi everyone,

I just started to use .Net and Sharepoint

I just want to know if it is possible to apply the sorting of the data in the SPGridView on Pageload?

If it is not, I need help to do the following:

get data from a list using CAML query and then use it as Datasource for the SPGridView...

Best Regards,

Michael

re: SPGridView and SPMenuField: Displaying custom data through SharePoint lists

itsaliakber — Wed, 29 Jul 2009 16:37:55 GMT

Thanks a lot Paul for such an awesome article.

I would like to know, when grouping if i just wanted to display only the column value nothing else, how will i get it. Though i had remove GroupDescriptionField & GroupFieldDisplayName. The Groupfield is being displayed.

Thanks a million in advance