We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
ASP.NET Dynamic Data Filtering not working
38 replies
Last post Sep 09, 2010 06:11 AM by sjnaughton
Last post Sep 09, 2010 06:11 AM by sjnaughton
Member
444 Points
346 Posts
ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 10:45 AM|levalencia|LINK
Hello. I am trying to use this DLL to make searches on dynamic data pages
http://www.codeplex.com/DynamicDataFiltering
I pasted the following code, but nothing happens
<cc1:DynamicFilterForm ID="DynamicFilterForm1" DataSourceID="GridDataSource" runat="server">
<FilterTemplate>
<table>
<tr>
<td>
Nombre activo</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl3" runat="server" DataField="Name"
FilterMode="Contains" /></td>
<td>
Marca</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl1" runat="server" DataField="Brand"
FilterMode="Contains" /></td>
</tr>
<tr>
<td>
Modelo</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl2" runat="server" DataField="Model"
FilterMode="Contains" /></td>
<td>
Ubicacion</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl4" runat="server" DataField="Location"
FilterMode="Contains" /></td>
</tr>
<tr>
<td>
Serial</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl5" runat="server" DataField="Serial"
FilterMode="Contains" /></td>
<td>
Sucursal</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl6" runat="server" DataField="Branch"
FilterMode="Equals" /></td>
</tr>
<tr>
<td>
Tipo de Servicio</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl7" runat="server" DataField="ServiceType"
FilterMode="Equals" /></td>
<td>
Capacidad</td>
<td>
<cc1:DynamicFilterControl ID="DynamicFilterControl8" runat="server" DataField="Capacity"
FilterMode="Contains" /></td>
</tr>
<tr>
<td colspan="4">
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Search" CausesValidation="false">Search</asp:LinkButton><br />
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="Clear" CausesValidation="false">Clear</asp:LinkButton><br />
<asp:LinkButton ID="LinkButton3" runat="server" CommandName="Browse" CausesValidation="false">Browse</asp:LinkButton>
</td>
</td>
</tr>
</table>
</FilterTemplate>
</cc1:DynamicFilterForm>
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 11:11 AM|levalencia|LINK
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataSourceID="GridDataSource"
OnDataBound="OnGridViewDataBound" OnRowCreated="OnGridViewRowCreated"
OnRowDeleted="OnGridViewRowDeleted" OnRowEditing="OnGridViewRowEditing"
OnRowUpdated="OnGridViewRowUpdated"
OnSelectedIndexChanging="OnGridViewSelectedIndexChanging"
style="text-align: center; margin-right: 1px;"
onrowcommand="GridView1_RowCommand" Width="100%" EnableQueryStringSelection="True">
<PagerStyle />
<RowStyle CssClass="row" />
<Columns>
<asp:DynamicField DataField="Name" HeaderText="Nombre activo" />
<asp:DynamicField DataField="Brand" HeaderText="Marca" />
<asp:DynamicField DataField="Model" HeaderText="Modelo" />
<asp:DynamicField DataField="Location" HeaderText="Ubicacion" />
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton CommandName="Editar" CausesValidation="false" ID="EditButton" ImageUrl="~/App_Themes/SodexoTheme/ImageLibrary/icoEdit.png" runat="server" Text="Editar" ToolTip="Editar" />
<asp:ImageButton CommandName="Delete" CausesValidation="false" ID="DeleteButton1" ImageUrl="~/App_Themes/SodexoTheme/ImageLibrary/icoDelete.png" runat="server" Text="Eliminar" ToolTip="Eliminar" OnClientClick='return confirm("Are you sure you want to delete this item?");' />
</ItemTemplate>
<EditItemTemplate>
<asp:ImageButton CommandName="Update" CausesValidation="true" ID="EditButton" ImageUrl="~/App_Themes/SodexoTheme/ImageLibrary/icoEdit.png" runat="server" Text="Actualizar" ToolTip="Actualizar" />
<asp:ImageButton CommandName="Cancel" CausesValidation="false" ID="DeleteButton1" ImageUrl="~/App_Themes/SodexoTheme/ImageLibrary/icoDelete.png" runat="server" Text="Cancelar" ToolTip="Cancelar" OnClientClick='return confirm("Are you sure you want to delete this item?");' />
</EditItemTemplate>
</asp:TemplateField>
</Columns>
<HeaderStyle CssClass="tableHead" />
<PagerTemplate>
<asp:GridViewPager runat="server" />
</PagerTemplate>
<EmptyDataTemplate>
No se encuentran registros.
</EmptyDataTemplate>
<AlternatingRowStyle CssClass="alternateRow" />
</asp:GridView>
<br />
<br />
<asp:LinqDataSource ID="GridDataSource" runat="server" EnableDelete="true" EnableUpdate="true">
<%-- <WhereParameters>
<asp:DynamicControlParameter ControlID="FilterRepeater" />
</WhereParameters>--%>
</asp:LinqDataSource>
<asp:Panel ID="DetailsPanel" runat="server">
<br /><br />
<asp:LinqDataSource ID="DetailsDataSource" runat="server" EnableDelete="true" EnableInsert="true" EnableUpdate="true">
<WhereParameters>
<asp:DynamicControlParameter ControlID="GridView1" />
</WhereParameters>
</asp:LinqDataSource>
</asp:Panel>
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 11:35 AM|sjnaughton|LINK
Hi Levalencia, are you trying to get it working on a file based website or a Web Application Project?
if you are trying to get it working on a file based website I have just done a tutorial on my blog here: Dynamic Data Futures – Part 1 Adding Advanced Filters
Hope this helps [:D]
Dynamic Data Dynamic Data Futures Advanced Filters
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 12:04 PM|levalencia|LINK
Its a website, but its on IIS not on a folder.
That tutorial seems too long, isnt there a faster way
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 12:39 PM|sjnaughton|LINK
Does it have a App_Code folder? if so then my tutorial will work for you, I know it's long winded but I didn't want to miss out and step. Once you have run through it a couple of time it easy. [:D]
Dynamic Data Dynamic Data Futures Advanced Filters
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 12:46 PM|levalencia|LINK
No, it doesnt have the app_code folder, what may be the problem?
Thx
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 12:49 PM|sjnaughton|LINK
So did you create it via Create Website or Create Project?
Dynamic Data
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 12:56 PM|levalencia|LINK
I tried the following
<cc1:DynamicLinqDataSource ID="DynamicLinqDataSource1" TableName="Assets" ContextTypeName="Sodexo.Data.ModelDataContext" runat="server">
</cc1:DynamicLinqDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataSourceID="DynamicLinqDataSource1"
OnDataBound="OnGridViewDataBound" OnRowCreated="OnGridViewRowCreated"
<asp:LinqDataSource ID="GridDataSource" runat="server" EnableDelete="true" EnableUpdate="true">
<%-- <WhereParameters>
<asp:DynamicControlParameter ControlID="FilterRepeater" />
</WhereParameters>--%>
</asp:LinqDataSource>
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 01:00 PM|levalencia|LINK
I got this error after trying that!
The ContextTypeName property of LinqDataSource 'GridDataSource' must specify a data context type.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: The ContextTypeName property of LinqDataSource 'GridDataSource' must specify a data context type.
Source Error:
Member
50 Points
43 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 04:46 PM|jheyse|LINK
Levalencia,
You must change the type of the LinqDataSource to cc1:DynamicLinqDataSource.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 04:59 PM|levalencia|LINK
I already followed all your tutorial.
Now please tell me how can I put filters on some field and some others not?
I have this in my metadata
[DisplayName("Activo")]
public class AssetMetaData
{
public object Id { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Nombre Activo")]
[Filter(FilterControl = "String")]
public object Name { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Descripción Activo")]
public object Description { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Marca")]
public object Brand { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Modelo")]
public object Model { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Serial")]
public object Serial { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Ubicación")]
public object Location { get; set; }
[DisplayName("Sucursal")]
public object Branch { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Capacidad")]
public object Capacity { get; set; }
[DisplayName("Tipo de Servicio")]
public object ServiceType { get; set; }
}
But it showed me the following error
The filter control 'CategoryFilter' does not support this operation because it is associated with an unsupported column 'Name'.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 05:02 PM|levalencia|LINK
I tried this, with no success.
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Nombre Activo")]
[Filter(FilterControl = "Autocomplete")]
public object Name { get; set; }
The same exception is thrown
Member
50 Points
43 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 05:17 PM|jheyse|LINK
The current release of Dynamic Data Filtering does not support Filter attributes on the Metadata Model. I am working on implement that as well as a corresponding DynamicFilterRepeater, they both should be available monday. In the mean time you must use the DynamicFilterForm.
The exception you show is because you commented out the LinqDataSource with the ID=GridDataSource and created a DynamicLinqDataSource with the ID=DynamicLinqDataSource1. If you modify the DynamicLinqDataSource's ID it should work.
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 05:18 PM|sjnaughton|LINK
My tutorial is for using Dynamic Data Futures with a File Based Website not a Web Application Project and also It requires the RTM of SP1 and the Dynamic Data Futures project.
I've tested my steps twice now and the Filters work after them, I don't know what else to say...
Dynamic Data Dynamic Data Futures Advanced Filters
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 05:30 PM|levalencia|LINK
I have done all what you said, exactly as your steps indicate and it compiles perfect. I wont use dynamic data filtering for now, I will try to use asp.net dynamic data futures. I am stuck in this moment because the error says
The filter control 'CategoryFilter' does not support this operation because it is associated with an unsupported column 'Name'.
It seems its try to loading another filter control.
?
Member
50 Points
43 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 05:52 PM|jheyse|LINK
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 05, 2008 06:05 PM|levalencia|LINK
I feel so stupid now.
I had this line
<asp:DynamicFilter runat="server" ID="CategoryFilter" ContextTypeName="Sodexo.Data.ModelDataContext" TableName="Assets" DataField="Name" OnSelectedIndexChanged="OnFilterSelectedIndexChanged" />
and I didnt erase it, this line was a tryout from another DLL called asp dynamic data filtering on codeplex or something like that
I feel very very stupid :)
Sorry for making you lose time
Thx
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 06, 2008 05:12 AM|sjnaughton|LINK
So In the end did you get Dynamic Data Futures Advanced Filtering working or Dynamic Data Filtering on codeplex?
Dynamic Data Dynamic Data Futures Advanced Filters
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 06, 2008 11:09 AM|levalencia|LINK
I am working with Dynamic Data Futures Advanced Filtering , but I still have some errors, I will let you know on Monday when I get back to work.
Thanks
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 06, 2008 11:28 AM|sjnaughton|LINK
Hi Levalencia , I've just update the project and here's the link:
An Advanced FieldTemplate with a GridView/DetailsView Project.
I've added the ShowColumns attribute to both FieldTemplates now and the ability to enable the Edit, Delete and Insert links, but not the Select link I'll leave that to you
(It's not there because I could'nt see a use for it in that situation).
Hope this helps
Dynamic Data FieldTemplates GridView Data DetailsView
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 08, 2008 10:53 AM|levalencia|LINK
I have the following problem}
var fkColumn = Column as MetaForeignKeyColumn;
fkcolumn is null
so the autofilter is not working
autoComplete1.ContextKey = AutocompleteFilterService.GetContextKey(fkColumn.ParentTable);
amespace Sodexo.Entities
{
[MetadataType(typeof(AssetMetaData))]
public partial class Asset
{
}
[DisplayName("Activo")]
public class AssetMetaData
{
public object Id { get; set; }
[DisplayName("Nombre Activo")]
[Required(ErrorMessage = "Este campo es Requerido")]
[Filter(FilterControl="Autocomplete")]
public object Name { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Descripción Activo")]
public object Description { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Marca")]
public object Brand { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Modelo")]
public object Model { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Serial")]
public object Serial { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Ubicación")]
public object Location { get; set; }
[DisplayName("Sucursal")]
public object Branch { get; set; }
[Required(ErrorMessage = "Este campo es Requerido")]
[DisplayName("Capacidad")]
public object Capacity { get; set; }
[DisplayName("Tipo de Servicio")]
public object ServiceType { get; set; }
}
}
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 08, 2008 11:10 AM|sjnaughton|LINK
Can you debug to that line:
var fkColumn = Column as MetaForeignKeyColumn;
and check to see if Column is of type MetaForeignKeyColumn? if not then thats your problem the AutocompleteFilter only works with FKColumns. It should be possible to change things so that it works with any column just as the Integer Filter works with any none key column.
Hope this helps [:D]
Dynamic Data Dynamic Data Futures Advanced Filters
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 08, 2008 11:16 AM|levalencia|LINK
That column is not a foreign key, that should be the problem.
The integer filter works, but it shows a dropdownlist, If I have 1000 rows, that will be a problem
I want a text filter or autocomplete filter, so the user can write anything and search for it.
Any ideas please?
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 08, 2008 11:29 AM|sjnaughton|LINK
Hi levalencia, I'll look at making the Autocomplete work with any column shouldn't be a problem, I'll have a look right away [:D]
Dynamic Data Dynamic Data Futures Advanced Filters
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 08, 2008 11:43 AM|levalencia|LINK
You are the best, I will wait here for the solution.
Thank you very much!
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 09, 2008 02:05 PM|sjnaughton|LINK
Hi Levalencia, I've got that Autocomplete on any column working now (I'm calling it AnyColumnAutocomplete) and will post the artlicle to my blog shortly [:D]
I've had to create a new Filter and modify the AutocompleteFilter Web Service.
Hope this helps [:D]
Dynamic Data Dynamic Data Futures Advanced Filters AnyColumnAutoComplete
Always seeking an elegant solution.
Member
444 Points
346 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 09, 2008 02:54 PM|levalencia|LINK
Please send me a private message when you have published it
Thank you very much.
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 09, 2008 05:52 PM|sjnaughton|LINK
Hi Levalencia, here's the post on my blog with project doweload: Part 3 – Creating the AnyColumnAutocomplete filter.
Hope this helps [:D]
Dynamic Data Dynamic Data Futures Advanced Filters AnyColumnAutoComplete
Always seeking an elegant solution.
Member
2 Points
11 Posts
Re: ASP.NET Dynamic Data Filtering not working
Dec 16, 2008 03:53 PM|lucbard|LINK
Hi
I am using AnyColumnAutocomplete but it doesn't work with numeric column type. I have a table called Budget and the PK is BudgetCode (int). I want the user to be able to type the BudgetCode as a filter but I had no success.
I this a bug or the AnyColumnAutocomplete only support String type columns?
Thanks,
Luc
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Dec 17, 2008 06:39 AM|sjnaughton|LINK
Hi AnyColumnAutoComplete works on the contents of the column it does not reach out over FK relationships but I'm sure that it could be modified to do that [:D]
Dynamic Data Advanced Filters
Always seeking an elegant solution.
Member
2 Points
11 Posts
Re: ASP.NET Dynamic Data Filtering not working
Dec 17, 2008 09:36 AM|lucbard|LINK
Well I am not talking about FK but a primary key. I have a table with a String primary key and the AnyColumnAutocomplete works fine.
I tried it on a regular integer column and it does not work.
Thanks,
Luc
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Dec 17, 2008 10:01 AM|sjnaughton|LINK
Have you tried it with a regular Iteger column i.e. not a PK column.
Also you could use the integer filter suppied with DD Futures [:D]
Dynamic Data Custom Field Templates
Always seeking an elegant solution.
Member
2 Points
11 Posts
Re: ASP.NET Dynamic Data Filtering not working
Dec 18, 2008 09:52 AM|lucbard|LINK
Yes that's what I was saying. I tried it with a regular integer Column with no success. The Interger filter works find but the dropdown list is to big :(
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Dec 18, 2008 02:07 PM|sjnaughton|LINK
I'll have a look over the holidays if I get chance and see if I can see whats going wrong. [:D]
Dynamic Data filters
Always seeking an elegant solution.
None
0 Points
2 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 02, 2010 12:19 PM|ricocsharp|LINK
why dynamic data futures and dynamic data filtering can't work together?
Member
242 Points
480 Posts
65,000 visits to this post ... uhmmm?
Sep 04, 2010 05:54 PM|klca|LINK
Hola,
I guess there might be some "misscounting" here ... Otherwise, CONGRATUALTIONS !!!!
Carlos Porras (El Salvador)
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 07, 2010 01:36 PM|sjnaughton|LINK
Hi ricocsharp, the certanly can an doo work together I have several projects out there on .Net 3.51 SP1 and DD working fine.
All you do is:
1. add the futures filtering to your project
2. follow instruction to add DDFiltering and all should work fine [:)]
Dynamic Data
Always seeking an elegant solution.
None
0 Points
2 Posts
Re: ASP.NET Dynamic Data Filtering not working
Sep 08, 2010 04:39 PM|ricocsharp|LINK
HI Steve, Maybe i was not clear enough so U did not understood me, basically i meant that using the autocomplete filter control U posted in a project using DD filtering i had errors in runtime like "the DynamicControl/DynamicFilter must be inside bla bla bla..." and asked for the sources of the dd Filetring assembly, finally I accomplished the task two days after my previous post.
Any way I will come back giving more details on this error and how i solved it.
Other thing your last fix to the autocomplete helped me very much and I did some twiks so now I can use it as a filter but also as a DD FilterTemplate Control and as a Field(this is not still 100% as I wish but will work like that soon)
To be more specific my exact need was to use this autocomplete to represent a FK that has more that 500 records so check for an existing property in a dropdown control of 500 elements is kind of crazy a idea so autocomplete textbox is the more suitable solution now I’m just lacking to make this autocomplete insert and edit also in other words convert this control of yours in a FieldTemplate.
See you and thanks a lot for your contributions to this technology
All-Star
17916 Points
5681 Posts
MVP
Re: ASP.NET Dynamic Data Filtering not working
Sep 09, 2010 06:11 AM|sjnaughton|LINK
Hi Rico, have a look at this article here Dynamic Data and Field Templates - An Advanced FieldTemplate should help inconverting it to a field template.
Dynamic Data
Always seeking an elegant solution.