Excel Like Filter for Gridview in asp.net

Question

I have a difficult yet interesting task to share with u all.I want to add the functionality of filtering to a gridview in my page.The UI of the filter should look like the one we see in Excel .On the Click of button in the header i should display a dynamically generated  context menu containing a checkbox list of all the contents in the column.Further I have to filter the gridview based on the items checked in the checkboxlist.

Please suggest the Feasibilities to achieve this task .I request you to post any available resources to guide me through this .

Thanks in Advance ….

Answer 1

One way to do is create a class called "Users" and have two static variable on it "UserName" and "UserType". Now once you store the variable in this class static variable you can get the value of it from any form.

Let me know if this solve your problem.

Answer 2

Im new to programming so this might not be right.

but i believe you dont want to create a global variable.

you want to define a method in the same class as your original form that returns The username and one that returns the usertype. 
  implement them somewhere between the constructor and destructor.   Then call it from the second form with a reference to the original class and method.

This is something i am going to try in the near future so im not sure on all of the specifics.  like i said i am new to this, but good luck and let me know if it helps, as i will be trying to do the same thing soon.