Bob's SharePoint Bonanza - All Comments

Bob's SharePoint Bonanza - All Commentshttp://www.sharepointblogs.com/bobsbonanza/default.aspxenCommunityServer 2007 SP2 (Build: 20611.960)re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#23467Fri, 28 Nov 2008 13:58:41 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:23467Tom<p>Arun, Nik and Nakago, I haven't tried this out myself, but the solution for the "adding multiple SPGridView Web Parts on one page" problem seems pretty easy for me... As the current filter and sort values are being saved in the ViewState, you need to make sure to use other ID's to save these for your different WebParts. I'm afraid you'll have to make a "GridView1" and "GridView2" for example, where the only difference is that they use other ID's, so there is no conflict anymore... (the "ID" I'm talking about is for example the "FilterExpression" in "ViewState["FilterExpression"] ").</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=23467" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#23201Thu, 20 Nov 2008 10:13:58 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:23201James<p>Babangida,</p> <p>For reference </p> <p>e.g.</p> <p>  <Columns></p> <p> <SharePointWebControls:SPBoundField DataField="__spTitle" HeaderText="Title">  </p> <p>   <itemstyle width="100px"/></p> <p>    </SharePointWebControls:SPBoundField>  </p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=23201" width="1" height="1">re: Deploying site columns and content types to sharepoint webshttp://www.sharepointblogs.com/bobsbonanza/archive/2007/12/17/deploying-site-columns-and-content-types-to-sharepoint-webs.aspx#23070Sun, 16 Nov 2008 13:28:01 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:23070Merlin, J<p>Hey great post!!!... can u please post the example invoking all the calls?</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=23070" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#22022Fri, 17 Oct 2008 03:00:00 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:22022Eric<p>After 2 days researching. I found out that the filtering function would not work if when paging function is enabled.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=22022" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#21423Tue, 30 Sep 2008 13:15:40 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:21423Nakago<p>Hi,</p> <p>I got a few more info about my problem while attempting to debug my code.</p> <p>I clicked on the button "Clear filter from <column name>" in the dropdown menu of one of my SPGridView columns' header, and checked the parameters in the HttpContext.Current.Request (i'll call this object request to make my post more readable).</p> <p>And I saw that request.Form["__EVENTTARGET"] = ctl00$PlaceHolderMain$GridView1$GridView1 so it contains the id of the first SPGridView I put on my page, even if I tried to clear filter from the second SPGridView.</p> <p>If I'm not wrong, this parameter should be the id of my second SPGridView, not the first one (so it should be something like ctl00$PlaceHolderMain$GridView2$GridView2), isn't it ? Does anyone has any idea to have the correct parameter here ? (Visual Studio debugger doesn't allow me to change this value at runtime, so I'm not sure it will solve my problem, but I think it's the path to the answer).</p> <p>Any help is welcome.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=21423" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#21392Mon, 29 Sep 2008 16:21:26 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:21392Nakago<p>Hi everyone,</p> <p>I'm facing the same problem Arun and Nik experiment : everything works great when there's only one instance of the webpart on my page, but when I put two of them, I observe a strange behaviour. Setting a filter is ok, but clearing a filter or sorting on a column is always done on the first webpart, no matter which one I wanted to sort or clear filter.</p> <p>Does anyone has any idea to solve this problem ? I've been testing for three days and didn't find anything.</p> <p>Thanks for any help.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=21392" width="1" height="1">SPGridView – sposób wykorzystania oraz ograniczeniahttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#21172Tue, 23 Sep 2008 22:33:48 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:21172.neting in the free world<p>Nie raz już w różnych przypadkach podawałem wam linki odnoszące się do SPGridView , pora się temu trochę</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=21172" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#21134Tue, 23 Sep 2008 08:27:04 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:21134Mahmoud<p>Can you please explain how can i set the objectDataSource TypeName property?</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=21134" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#20956Tue, 16 Sep 2008 23:09:00 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:20956Edward M.<p>Hi,</p> <p>After a full day I was unable to get your example working.</p> <p>Anyway you could post the full project or email it to me?</p> <p>I know how that sounds, sorry.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=20956" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#20283Thu, 28 Aug 2008 08:38:51 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:20283sunil<p>i have 2 dropdown lists Company and Client which are populated from SQL database, i am not able to see the Client DropDown refreshing when I select the Company. Please let me know what is missing from my code below</p> <p> <asp:DropDownList runat="server" id="ddlCompany" DataSourceID="SqlDataSource1" DataTextField="CompanyName" DataValueField="ID" AutoPostBack="True" DataMember="DefaultView" AppendDataBoundItems="True"></asp:DropDownList></p> <p> <asp:DropDownList runat="server" ID="ddlClientName" DataSourceID="dsClientInfo" DataTextField="FirstName" DataValueField="ID" AutoPostBack="true"></asp:DropDownList></p> <p> <asp:sqldatasource</p> <p>  id="SqlDataSourceCtrl"</p> <p>  runat="server"</p> <p>  ConnectionString="Data Source=MDS\SQLEXPRESS;User ID=sa;Password=qwerty;Initial Catalog=HanInfo;" </p> <p>  selectcommand="SELECT * FROM tb_Client WHERE CompanyID = @CID"></p> <p>  <selectparameters></p> <p>      <asp:controlparameter name="CID" controlid="ddlCompany"  propertyname="SelectedValue"/></p> <p>  </selectparameters></p> <p> <FilterParameters></p> <p> <asp:controlparameter ControlID="ddlCompany" PropertyName="SelectedValue" DefaultValue="2" Name="fltCID" Type="Int16" /></p> <p> </FilterParameters></p> <p> </asp:sqldatasource></p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=20283" width="1" height="1">How to: Professionelle Datenanzeige mit dem Control SPGridView - Meine SharePoint-Notizenhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#20113Fri, 22 Aug 2008 11:20:23 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:20113How to: Professionelle Datenanzeige mit dem Control SPGridView - Meine SharePoint-Notizen<p>Pingback from  How to: Professionelle Datenanzeige mit dem Control SPGridView - Meine SharePoint-Notizen</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=20113" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#20066Thu, 21 Aug 2008 13:06:34 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:20066Oliver Wirkus<p>Just got it done! I managed to get the little cone icon diplayed just next to the filtered column.</p> <p>If anybody is interessted in how to do it, just have a look on my article - here is the link:</p> <p><a rel="nofollow" target="_new" href="http://www.sharepointblogs.com/wirkus/archive/2008/08/21/how-to-professionelle-datenanzeige-mit-dem-control-spgridview.aspx">www.sharepointblogs.com/.../how-to-professionelle-datenanzeige-mit-dem-control-spgridview.aspx</a></p> <p>Thanks to Robert - without his post I would have had more trouble with my little SPGridView-demo.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=20066" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19947Mon, 18 Aug 2008 13:51:59 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19947Oliver Wirkus<p>Very good work :-)</p> <p>The only thing I'm missing is the little filter icon indicating that the data that is displayed is filtered.</p> <p>Does anybody know how to add this little icon in case filtering is active?</p> <p>Regards,</p> <p>Oliver</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19947" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19942Mon, 18 Aug 2008 10:55:45 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19942Tester<p>:-)</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19942" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19929Mon, 18 Aug 2008 07:12:57 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19929Nik<p>Hi Bob,</p> <p>Same problem here.</p> <p>When there is only one webpart in the page, everything works fine. But when one more is added, sorting is becoming weired. When sorting menu item of the second webpart is clicked, the first webpart gets sorted. The webpart on wheich the drop down menu item is clicked remains unchanged. But sorting works when the column title is clicked instead of the dropdown menu.</p> <p>Thank you,</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19929" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19883Fri, 15 Aug 2008 10:16:58 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19883Arun<p>Hello Bob, </p> <p>Thank you for sharing the information.</p> <p>I have a problem with Sorting of SPGridView control in a custom webpart. At first, sorting of SPGridView works perfectly when I click on the column header link as well as dropdown menu item. </p> <p>But if I place more than one instance of same webpart in a page, I am experiencing a strange problem when the drop down menu is used for sorting selection. No matter what webpart instance is clicked,it only sorts the FIRST webpart in the page. Also there is no problem when the column header link is clicked, it works fine. </p> <p>I tried many workarounds, but couldn’t solve the issue. Is this happens with multiple gridviews in a same page?</p> <p>I</p> <p>Please help me.</p> <p>Thanks in advance!</p> <p>-Arun</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19883" width="1" height="1">用SPGridView显示SharePoint内容http://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19335Wed, 30 Jul 2008 09:50:07 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19335Joycode@Ab110.com<p>&#160;&#160;&#160; 我们在SharePoint上查看列表视图的时候，默认的那个Web部件（ListViewWebPart）提供了丰富且友好的功能，可以在上面进行排序、筛选等操作，每个列表条目上还有一个友好的下拉菜单</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19335" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19242Sun, 27 Jul 2008 08:35:14 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19242Dudi Nissan<p>I solve the problem myself:</p> <p>I did the databinding in the CreateChildControls method after Controls.Add(SPGridiew).</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19242" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19224Fri, 25 Jul 2008 19:30:50 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19224Dudi Nissan<p>Hello,</p> <p>If I do the databinding in the Render method, I get "Object Reference" exception because the SPGridView is null.</p> <p>If I do the databinding in the CreateChildControls method, I get the following error: "The SPGridView control 'mySPGrid' does not have a naming container.  Ensure that the control is added to the page before calling DataBind"</p> <p>Any Ideas?</p> <p>Thank you.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19224" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#19028Mon, 21 Jul 2008 13:46:03 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:19028Terrabit - Alex<p>Hi guys,</p> <p>here an sample for filtering columns with different datatype:</p> <p>            oGrid.DataKeyNames = new string<img src="http://www.sharepointblogs.com/emoticons/emotion-14.gif" alt="Devil" /> { "Status", "ProdOrderNo", "RoutingReferenceNo", "RoutingNo", "OperationNo", "Description" };</p> <p>            oGrid.FilterDataFields = ",StartingDate,EndingDate,RoutingStatus";</p> <p>            oGrid.FilteredDataSourcePropertyName = "FilterExpression";</p> <p>            oGrid.FilteredDataSourcePropertyFormat = "IIF('{1}' = 'StartingDate' OR '{1}' = 'EndingDate',{1} = '#{0}#',{1} = '{0}')";</p> <p>            oGrid.AllowFiltering = true;</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=19028" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#18198Mon, 30 Jun 2008 10:11:15 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:18198Seamus<p>Thanks... Allan asked</p> <p>I am trying to get the code working with a DataView instance instead of the ObjectDataSource, but by some it reason I can't get it running. Shouldn't that be possible?</p> <p>Has anyone tried to use a DataView with the code?</p> <p>I need the same - did anyone have any success?</p> <p>Best wishes</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=18198" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#17438Tue, 10 Jun 2008 04:10:26 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:17438Moorthy<p>Hi,</p> <p>Currently i can able to GroupFields in GridView and if I enable sorting then more than one Grouping for single groupfield appears.</p> <p>I need to Sort items within GroupField.</p> <p>Pls help me.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=17438" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#17405Mon, 09 Jun 2008 12:41:53 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:17405Moorthy<p>Hi,</p> <p>Currently i have enabled Grouping and sorting in SPGridView.</p> <p>I need to sort the items based on Group field but for me the items got sorted and then its getting grouped.</p> <p>Pls help me to Sort the items based on Grouping.</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=17405" width="1" height="1">Custom Filters in SPGridView « Ketul’s Webloghttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#17087Fri, 30 May 2008 22:59:02 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:17087Custom Filters in SPGridView « Ketul’s Weblog<p>Pingback from  Custom Filters in SPGridView &laquo; Ketul&#8217;s Weblog</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=17087" width="1" height="1">re: Filtering with SPGridViewhttp://www.sharepointblogs.com/bobsbonanza/archive/2007/07/02/filtering-with-spgridview.aspx#16946Wed, 28 May 2008 11:26:21 GMT1f6a1193-f4bb-4480-a5ae-b538d8b20f46:16946Dinesh<p>Very good post</p> <hr><span style="font-size:10pt;">Posted on <a href="http://www.sharepointblogs.com/">SharePoint Blogs</a></span> <img src="http://www.sharepointblogs.com/aggbug.aspx?PostID=16946" width="1" height="1">