Re: Updated:Filter for DataGridView - C# Discussion Boards

11-Aug-09 2:14

Hi,
Please let me know how to add a filter for DataGridView so that the user can enter the filter condition in the corresponding column header to filter the rows that match the condition.

I am new to C#. Requirement is simillar to how it is in Mercury Quality center or TestDirector tools.

Hope the question is clear..

Thanks & Regards,
Dhana

modified on Tuesday, August 11, 2009 8:29 AM

Sreedhar Kadiyala11-Aug-09 2:49

Sreedhar Kadiyala

11-Aug-09 2:49

Hi,

Since the DataTable source is assigned to DataGridView, you can filter the DataTable by using
DataTable.DefaultView.RowFilter="ColName=" + ColValue
It will automatically apply to the DataGridView

Sreedhar

janadhana11-Aug-09 19:36

11-Aug-09 19:36

Thanks very much..i am now using the simillar code for implementing the filter.

Thanks & Regards,
Dhana

dan!sh 11-Aug-09 2:58

dan!sh

11-Aug-09 2:58

If this is a bound DataGridView, you are not allowed to add rows. Hence you will need to extend the DataGridView if you need a filter like Quality center.

A quick and dirty (and may be "not recommended") way is:
1. Provide padding the headercell.
2. Add a textbox to the DataGridView at the location right above the first row.(You will need to play with the location of the textbox)
3. Handle its TextChanged event and set the RowFilter property of the datatable you have.

A better solution IMO will be to have a button and display a modal window where in user can apply filter.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

janadhana11-Aug-09 19:37

11-Aug-09 19:37

Thanks very much..I have followed the steps that you have given and created it..as you said it is ugly..it seems the same to me..I am trying to make it more clean.

Thanks & Regards,
Dhana

Henry Minute11-Aug-09 5:00

Henry Minute

11-Aug-09 5:00

Does DataGridView Filter Popup[^] help?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

janadhana11-Aug-09 19:39

Getting duration of audio file with c#

11-Aug-09 19:39

I think this is wanted i actually wanted..thanks very much..I trying to incorporate this framework. Thanks very much..it has really helped me ..

Thanks & Regards,
Dhana

q in datagirdview

mohammad alnoed11-Aug-09 1:15

mohammad alnoed

11-Aug-09 1:15

Hi All,

I am having problems adding a new row to a datagridview control in my form. I have a simple form
a datagridview. When the user types in an item number at columen one , the system will populate the datagridview with the relevant data from the database.

Re: q in datagirdview

padmanabhan N11-Aug-09 1:35

padmanabhan N

11-Aug-09 1:35

how far have you tried... can you send the code ....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Re: q in datagirdview

Arindam Sinha11-Aug-09 1:39

Arindam Sinha

11-Aug-09 1:39

mohammad alnoed wrote:
a new row to a datagridview control in my form

Try out the following code -

dataGridView1.AlloUserToAddRows = True;

Keep me posted if this resolves your problem. Smile | :)

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

Re: q in datagirdview

Henry Minute11-Aug-09 2:12

Henry Minute

11-Aug-09 2:12

Take a look at this[^] thread. Although it is about a ComboBox in a DGV the same principle can be applied to hooking an event for a DataGridViewTextBox (or whatever you are using). All you have to do is decide which event is most appropriate for your needs.

SubarnaMishra11-Aug-09 1:13

SubarnaMishra

11-Aug-09 1:13

Hi,

Can anyone tell , how can I get duration of audio file with c#

Re: Getting duration of audio file with c#

DaveyM6911-Aug-09 1:29

where to find windows toolStrip icons??

11-Aug-09 1:29

This google search[^] yeilds plenty of results

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

reilak10-Aug-09 23:26

reilak

10-Aug-09 23:26

is there a location in the hard drive where one can find windows toolStrip icons?

Re: where to find windows toolStrip icons??

DaveyM6910-Aug-09 23:31

Re: where to find windows toolStrip icons??

10-Aug-09 23:31

IIRC they are in a subfolder of the common folder in the Visual Studio install. If you did a custom install, you may not have selected them so you will have to run set up and modify.

If you are running an express version, then they do not exist for you.

reilak11-Aug-09 1:16

reilak

11-Aug-09 1:16

I'm using express ):
i'll printScreen them... thanks!

String to Binary

Mohammad Dayyan10-Aug-09 23:12

Mohammad Dayyan

10-Aug-09 23:12

Hi all.
I wanna convert a string ( eg : "0110101" ) to equal of it in Binary ( 0110101 )

Could you please guide me ?
Thanks.

DaveyM6910-Aug-09 23:17

10-Aug-09 23:17

You can use:

int i = Convert.ToInt32 (binaryString, 2);

If you are doing a lot of this in your application you may find my article[^] useful.

0x3c010-Aug-09 23:21

0x3c0

10-Aug-09 23:21

Beat me to it. I had half a mind to post a home-made binary conversion function - I've been thinking about it for weeks Wink | ;)

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

DaveyM6910-Aug-09 23:28

10-Aug-09 23:28

I really need to revisit that article. It served the requirements that I had at the time so that's as far as I went with it, but it could be more useful with a little work. I was resonably new to C# then too so there are probably a few things that could do with refactoring.