how to filter data of grid

Question

0.00/5 (No votes)

See more:

i want to filter data of grid..
i have dropdown list in which column name of table. //assume dropdown list as ddlcolm.
i have another dropdown in which keyword like = > < //assumen dropdown as ddlkeyword.
i have another textbox in which we can enter data like name,id,status value

and one filter button is there...
so i want to select column name from ddlcolm and select keyword from ddlkeyword and enter date in textbox ...
suppose in textbox enter name is party nd click on filter button then i want to display in gridview data which name is 'party'.

so how can i do???
plz help me...
thanks in advance..

Posted 26-Oct-12 2:51am

Member 9027483

Add a Solution

Comments

_Amy 26-Oct-12 8:54am

What have you tried yet? Where you stuck?

Bhushan Shah1988 26-Oct-12 9:02am

so what is your problem?

Member 9027483 27-Oct-12 1:33am

i cant understand how i can match textbox value to gridvalue nd display grid data means at which point start coding nd where write code???
i m very confuse about this...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2012-10-26T03:01:00

Filter your datatable according to your requirement. Try something like this:

C#

var query = (from s in dt.AsEnumerable()
               where s[ddlcolm.SelectedValue] equals TextBox1 select s);
DataTable FilteredData = query.Count() > 0 ? query.CopyToDataTable() : null;
if(FilteredData != null)
{
     //bind your grid-view here.
}

--Amit

Ambesha · Answer 2 · 2012-10-26T03:04:00

Use the following links :

http://msdn.microsoft.com/en-us/library/bb470363(v=vs.100).aspx[^]
http://msdn.microsoft.com/en-us/library/aa479353.aspx[^]
http://social.msdn.microsoft.com/Forums/en-US/winforms/thread/fc9eef3c-cb54-4b92-9c81-54c630793fa1/[^]
http://stackoverflow.com/questions/12148993/how-to-load-the-data-in-aspgrid-after-providing-filters[^]

Thanks,
Ambesha

how to filter data of grid

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0