ansaurus

Question

Can multiple filters be used on a llblgen data source?

Answer 1

A:

I am unable to duplicate the behavior you are seeing in a simple test case (see below). Also, unless you are using parameter binding on the datasource, you shouldn't have to call DataBind on the DataSource control but only on the GridView.

Test Case:

DB contains 1 table Customer with two varchar(50) fields: FirstName and LastName.

Default.aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TestWebApp1._Default" %>
<%@ Register Assembly="SD.LLBLGen.Pro.ORMSupportClasses.NET20" Namespace="SD.LLBLGen.Pro.ORMSupportClasses" TagPrefix="llblgenpro" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
        <br />
        <br />
    <asp:GridView ID="CustomersGridView" runat="server" DataSourceID="dsCustomers">
    </asp:GridView>
    </div>
    <llblgenpro:LLBLGenProDataSource ID="dsCustomers" runat="server" 
        DataContainerType="EntityCollection" 
        EntityCollectionTypeName="TestWebApp1Framework.CollectionClasses.CustomerCollection, TestWebApp1Framework">
    </llblgenpro:LLBLGenProDataSource>
    </form>
</body>
</html>

Default.aspx.cs:

using System;
using SD.LLBLGen.Pro.ORMSupportClasses;
using TestWebApp1Framework.HelperClasses;

namespace TestWebApp1
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Button1_Click(object sender, EventArgs e)
        {
            var filter = new PredicateExpression();
            filter.Add(new FieldLikePredicate(CustomerFields.FirstName, null, TextBox1.Text.Trim() + "%"));
            filter.AddWithOr(new FieldLikePredicate(CustomerFields.LastName, null, TextBox1.Text.Trim() + "%"));
            dsCustomers.FilterToUse = filter;
            dsCustomers.DataBind();
            CustomersGridView.DataBind();
        }
    }
}

Test Results: Loading this page initially shows all customers. Entering the letter A into the textbox and clicking the button shows a list of all customers whose first name or last name starts with A. This shows that both filters are working correctly.

David Archer 2009-03-25 15:11:41

Updated the question to include the fact that the code is in a Button.Click event and there is nothing in the Page.Load method.

JamesEggers 2009-03-25 15:21:51

Hmm, just cleared all of my cache and cleaned the build and tried again and it seems to be working now. Weird. Thanks for the response and the test information!

JamesEggers 2009-03-25 16:55:33

ansaurus

tags:

views:

answers:

Can multiple filters be used on a llblgen data source?

related questions