.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

DVWP Filtering limit??

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :SharePoint


Can anyone comment on how many filtering arguments can a dvwp in SharePoint Designer handle?  It appears through our development process that 10 or 11 is the limit.  Supposedly you can edit the query using CAML but I am unsure as to where to locate the CAML code to do this.

ANy comments or suggestions would be greatly appreciated!



View Complete Post

More Related Resource Links

Filtering DVWP using a url parameter

Hi everyone,

I've created a DVWP and put a URL filtering using ParameterBinding:

  <ParameterBinding Name="Type" Location="Postback;Connection;QueryString(Type)" Default=""/>

The column on the subject is a choice type with 10 selections (example: apple, orange, pear,...). If I send a url MyDVWP.aspx?Type=apple, I get only apple rows. When "MyDVWP.aspx?Type=pear", I get only pear rows. My question is how can I make my DVWP to show all items?..

I guess I could make a URL parameters for each selection.. like one for apple, one for orange.  But that will be 10 URL parameters and doesn't sound like a good solution..

Can anyone come up with a better solution??..

GridView Filtering In ASP.NET

In this tutorial you will learn how to add a filter to a Grid View Control, To modify the query with a parameterized filter, the WHERE Clause, Parameter properties, Parameter Value Editor and To test filtering.

IIS request filtering module


Hi folks,

I have migrated my web application to iis 7.5 Now I am using windows 7 as dev machine.

the problem is it takes several seconds to download a single page into web browser now. It contains only 300 records.

Everything is ok on prod website though. Prod version contains up to 200000 records .I can't also use code profile tool of red gate to analyze possible bottlenecks since the software in question can't restart IIS. No errors in IIS logs. I am using ISAPI Rewrite 3 filter by Helicon to apply some URL rewriting rules. I am thinking about conflict between ISAPI rewriting rules and default IIS 7.5 request filtering rules, since the IIS request filtering module gets a higher priority than even the built-in IIS 7.5 rewriter module. Is it possible to tweak the module through web.config so that priority is given to ISAPI rewriting rules or something like that?

Frankly, I spent several days to figure out solution. No success...

I've also deployed the application on IIS 5.1. Everything works fine. Any ideas about possible solution for IIS 7.5?

HTTP Pipelines: Securely Implement Request Processing, Filtering, and Content Redirection with HTTP


ASP.NET is a flexible and extensible framework for server-side HTTP programming. While most people think of ASP.NET in terms of pages served, there is a lower-level infrastructure sitting beneath this page model. The underlying plumbing is based on a pipeline of app, module, and handler objects. Understanding how this pipeline works is key if you want to get the most out of ASP.NET as an HTTP server platform, while making your process more efficient, and keeping your server secure. This article introduces the architecture of the pipeline and shows how you can use it to add sophisticated functionality to an ASP.NET-based app.

Tim Ewald and Keith Brown

MSDN Magazine September 2002

Disable filtering on a Dynamic Data list view.


I have an entity set of NotificationTemplates, and each one of these has a collection of zero-many SmsTemplate entities. When editing or viewing a NotificationTemplate, I have a link to View SMS Templates. That link takes me to a List view for the SmsTemplates entity set, filtered for the NotificationTemplate I was viewing.

How can I prevent the user changing this filter to show SmsTemplates for another NotificationTemplate? That is, I want the filter, but it must be read only. The drop-down just mustn't drop down, it must just display the name of the NotificationTemplate that these SmsTemplates belong to. To view SmsTemplates for another NotificationTemplate, the user must click View SMS Templates from that other template.

This was originally asked by myself on SatckOverflow at: http://stackoverflow.com/questions/3514373/disable-filtering-on-a-dynamic-data-list-view

The file reached the maximum download limit. Check that the full text of the document can be meaning



I'm facing an issue with the indexing.

I have 1 WFE+Index server+DB server.

Index server is not installed with MS FIlter pack 1.0

When crawling, the there will be document with warning in crawl log:
The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled.

Documents that with warning are such as doc, ppt, xls, docs, ppts and many others.
However, I view into the successful crawled document, there are doucments with ext doc and ppt.

For large file index, there are MaxGrowthFactor + MaxDownLoadSize required to be added into the index server.

As my understanding is, MS Filter Pack should installed into index server(already did, correct me if i'm wrong).

I looked into the Office SharePoint Seach(CA>Services in farm), if the server is appointed to "Use this server as indexing server", then MS Filter Pack is suppose to be installed into that particular server as well.

At the bottom, there also has another option is "Use all web front end for crawling".

The question here is, IF the option "Use all web front end for crawling" is selected.
Does the WED FRONT END Server required to installed the Ms Filte

Dynamically Populate a DVWP depending on selected item



I am wanting to create a dashboard page with several data view web parts which dynamically populate depending on what item is selected in a separate web part (drop down form or just a list of links).  Can someone please point me to a tutorial or documentation on how to pass data between web parts or to a DVWP?  I have searched for a few hours and not been able to find anything useful.



DVWP filter values




I've created a DVWP that pulls data from three lists. I've enabled the filter/group/sort toolbar. Each of the lists has a Person field which I am able to display correctly in the table (using disable-output-escaping="yes"), however, the values in the Filter drop-down still have all the HTML code.  How can I get the values in the filter drop-down to display correctly?



'An unexpected error has occurred' on upload after changing limit



I recently changed the max upload size for attachments to TFS work items on our SharePoint site.  I did this by going to the http://tfsserver1:8080/tfs/ProductCollection/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx?op=SetMaxAttachmentSize URL and entering the new size in bytes.

This worked a treat, but not I cannot upload any documents to another site on the same server.

I can open and save documents that are already there, but when I click the 'Upload' button it gives a white page with 'An unexpected error has occurred.' on it.

Is there something else I have to set when I increase the upload limit for work items?


Filtering a grid column when the column is bound to a collection


My SetUp (I am using EF for my data):

1 Grid bound to a collection of Vehicle Objects

1 Combobox with multiselect enabled bound to a list of VehicleExtras.

Each vehicle has a collection of extras. 

My Problem:

What I need to do is have the Grid filter Vehicles based on whether those vehicles have the selected VehicleExtras from the Combobox

Can anyone point me in the right direction as to how this filtering should be done (if it is at all possible!)



Custom Filtering



I write a custom StringFilter to use as filter control for string properties, I use bellow code to "GetQueryable" method :

    public override IQueryable GetQueryable(IQueryable source)
        string selectedValue = TextBox1.Text;
        if (String.IsNullOrEmpty(selectedValue))
            return source;

        object value = selectedValue;
        if (DefaultValues != null)
            DefaultValues[Column.Name] = value;

        return ApplyEqualityFilter(source, Column.Name, value);
the disatvantage of this method is user must enter whoul string to find...
can any body help me to change this method to work such as sql "Like" method instead of equality ?


New Data does not show in DVWP


I have two web parts on the page. The left one has regions listed. Clicking on a region hte right web part (DVWP) displays the data about that region (sales, etc.). 

Everything works as expected. Now, I added a region. And the new region does not show up. The regions are in an SP list. I am using SP 2003 and SPD 2007. 

I can see the new region data in a standard view or a datasheet view.

Can someone please help? Thanks much.

DVWP not displaying a column as per the original list


I have a data view web part which displays a list column that allows multiple items to be selected from another list.  So in this column (in the actual list), the content in a particular cell is as follows:

6698; 1211; 3342; 1231; 1231

However, when I insert this field into the DVWP, the content above ends up losing all the spaces and so looks like this:


I am not sure why this is happening, and plus some of the entries in this column are made up of a very long string of numbers.  Even if I control the width of the column, this long list only ever gets displayed on one line (i.e. width restriction is ignored), therefore my page is being displayed very wide.  I think this is happening because of the lack of spaces in the string, but am not sure.

Does anyone know what is going on here?

Thanks for taking time to read.

Filtering/selecting rows based on date


I have a gridview, based on thsi datasource:


<asp:SqlDataSource ID="SqlDataSourceAllLoads" runat="server" 
        ConnectionString="<%$ ConnectionStrings:tplatz_dk_dbConnectionString %>"               
        SelectCommand="SELECT DISTINCT DATEADD(day, 0, DATEDIFF(day, 0, tblDelivered.delivered_Date)) AS delivered_Date, tblDelivered.delivered_LoadNo, tblDelivered.delivered_TrailerNo, ISNULL(tblDeliveredInfo.deliveryInfo_FirmaNavn, N'?') AS Expr1 FROM tblDelivered FULL OUTER JOIN tblDeliveredInfo ON tblDelivered.delivered_LoadNo = tblDeliveredInfo.deliveryInfo_LoadNr ORDER BY delivered_Date DESC">

Using a dropdownlist, I can filter (by changing datasource) the results based on customer names in a dropdownlist. This datasource, working perfectly, looks like this:


<asp:SqlDataSource ID="sqldataSourceKundeLoads" runat="server" 
        ConnectionString="<%$ ConnectionStrings:tplatz_dk_dbConnectionString %>" 
        SelectCommand="SELECT  DATEADD(day, 0, DATEDIFF(day, 0, tblDelivered.delivered_Date)) AS delivered_Date, tblDelivered.delivered_LoadNo, tblDelivered.delivered_TrailerNo, ISNULL(tblDeliveredInfo.deliveryInfo_FirmaNavn, N'?&#

SQLCompact 3.5 NText Limit

Hi my question is simple: How can i store more than 4k characters in a database column.  Im using compact 3.5 and NVarChar limits it to 4000 characters.  Someone suggested i use NText, but when i select that datatype the designer sets the maxlength to 16 and wont let me change it. Im looking to store around 10k-15k characters max in the field, whats the best (if any) way?Software Developer and Web Designer

limit ASP.NET User Session without blocking production

 If the Web Site is in production and there are hits from one particular place (Say London!) and the after 1000 (or x) requests, user session should not be allowed. So what to do in such situation without affecting current production site?  Please Advice. Thanks!  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend