65.9K
CodeProject is changing. Read more.
Home

Generate Filter String

starIcon
emptyStarIcon
starIcon
emptyStarIconemptyStarIconemptyStarIcon

1.48/5 (6 votes)

Oct 15, 2007

viewsIcon

23271

downloadIcon

165

Generate Filter String as per user requirment

Screenshot - filter.jpg

Introduction

Here I introduce one filter control base on query

Using the Code

In this code I am create one usercontrol so

1) Register a usercontrol

<%@ Register TagName="Filter" TagName="Filter" TagPrefix="UC" 
    Src="~/filtercontrol/FilterControl.ascx" %>

2) Pass appropriate data

in page load method

you have to pass one two dimension string array

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            string[,] col = new string[2, 2];
            col[0, 0] = "val";
            col[0, 1] = "coltex1";
            col[1, 0] = "val2";
            col[1, 1] = "coltext2";

            filter1._Collumname = col;

        }
    }

3) use function

On button click even use the function for gating filter string and clear the filter criteria

    protected void Button1_Click(object sender, EventArgs e)
    {
        Label1.Text = filter1.filterstring();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        filter1.blankfilter();
    }<o:p />

i am apply this user control for filter the record in recordset , view state etc.

you can also change the code for your requirment