How to filter columns in each DataGridView coming from DataTable?

Question

0.00/5 (No votes)

See more:

.NET2.0

Hi, in the process of designing and implementing a software system, I have been running into various performance issues. As a result, I am trying to figure ways to minimize memory usage and increase reading and writing performance. I stumbled upon the possibilities of using a DataTable for storing and handling parts of my database; however, I am not quite familiar with it, and its association with DataGridView, so I am asking for some pointers in this area.

What I want to do is to have a single large DataTable. I want to display certain columns of the table in a DataGridView - different columns in each DataGridView. If I change the contents of the DataTable, the changes will be reflected back in all the DataGridView.

My trouble is that I can't figure out three things:

1. Will a change on DataTable be reflected as similar change on all associated DataGridView?

2. How do I filter out certain columns of DataGridView when the contents are coming from DataTable? Is it doable only with using DataView.ToTable() because it creates a copy of the table; thus, using more memory?

3. Can I set the last column as hidden in each of the DataGridView?

Posted 29-Nov-11 16:23pm

Que Trac

Add a Solution

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)

umutarge · Accepted Answer · 2011-11-30T02:36:00

Solution 1

If you bind a datatable to datagridview as datasource, the changes you made on datatable also occurs on datagridview. I don't know if there is a short way, but you can code a method in order to filter a specific field of datatable. Please check

C#

DataRow.Field(string name)

method.

Posted 30-Nov-11 2:36am

umutarge

Updated 30-Nov-11 2:40am

v2

Leeland Clay · Accepted Answer · 2011-11-30T02:51:00

Yes, any change within the datatable will be reflected on the DataGridView's(DGV) once the control goes through a databind method (postback, or manual call if using ajax).

The easiest way that I've seen to filter the columns is to set the AutoGenerateColumns to false and then create the columns you want within the Columns container of the DGV.You can still use bound fields, you will just have to define them manually. You can also do this from codebehind if you need it to be dynamic.

You then have total control over what's visible and what's not. All you have to do is set the Visible option on the column entry. Also, if you will be using the built in edit/delete buttons you will need to set the DataKeyNames to the column name that holds the row's ID entry.