Josh Heyse

Looks like a great extension for DynamicData - but could I have just a little word of tuition?

I'm trying to use NotNullOrEmptyParameter - I have it in Parameters collection of DynamicLinqDataSource, set its Name, DefaultValue and I would think it should weed out rows with Field(Name) set to null. I can see it added to WhereParameters in OnSelecting event of datasource (of course), but on influence on result set?

Hi There

I have been trying out your code, and think it is great.  The degree of flexibility in filtering is fantastic.

I have a problem however, that maybe you could shed some light on?

I noticed that when the DynamicFilterForm is bound, a query is executed against my DB to retrieve all rows.  If there are foreign keys, then all foreign key tables are joined.  This makes for a slow page load with large numbers of rows.

Setting A break point in the OnSelecting method in the DynamicLinqDataSourceView shows that on the initial page load, when the DynamicFilterForm binds, the LinqDataSourceSelectEventArgs Arguments have values of MaximumRows 0, SortExpression="", StartRowIndex=0.   However, on subsequent post backs the values reflect the pagesize, startrowindex and sortexpression of the gridview.  This results in a much quicker page load on postback.

Can you point me in the right direction as to where I should look to improve the initial page load by reducing the number of rows returned when the DynamicFilterForm is first bound.

Many thanks, and good work

Tatsky

Hi again

After my post yesterday I have played around with the code some more, and have implimented the following overide in the DynamicFilterForm

       protected override DataSourceSelectArguments CreateDataSourceSelectArguments()

       {

         DataSourceSelectArguments args = base.CreateDataSourceSelectArguments();

         args.MaximumRows = 1;

         return args;

       }

This ensures that when the FilterForm binds, only 1 row is returned from the Database.  This has solved the issue I was having.

Can you see any obvious problem with doing this?

Thanks

Tatsky

Josh,

This looks like an great addition to DynamicData projects, but from reading the blog posts and comments, I get the impression that I'm missing something.  Your AdventureWorks sample project has a separate folder for "Products" and has a customized Search page there.  This seems like it's counter to the purpose of "Dynamic" data.  Is there a way to drop a DynamicFilterForm on the List.aspx page and have a filter form for every table without having to hard code it for each table?

Thanks for the great control and any help that you can provide.

How can i fill dropdownlist  to search with primary key