Can we filter columns in a dataset ?

  • Thread starter Thread starter Chak
  • Start date Start date
C

Chak

Just as we use RowFilter, to choose a subset of rows , i wish to get s
subset of the columns. The workaround i could think of was to read the
DataTable again with only required columns eg - SELECT COL1 FROM DT1 where
DT1 is the memory datatable.

1) Is it possible to apply a SELECT on a DataTable ?

2) How would one pick only the required columns after populating the dataset
?

Regards.
 
Chak,

For Net 1.x you can use the styles from a datagrid

For Net 2.0 you can beside that use the overloaded version from the
DataView.ToTable to create a seperated datatable.

I hope this helps,

Cor
 
Hi Chak,

Depends on the data consumer as this is a job for UI.
Which one are you using?
 
Thanks. Am using the Windows forms datagrid in 1.1

Regards,

Chak.


Miha Markic said:
Hi Chak,

Depends on the data consumer as this is a job for UI.
Which one are you using?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Chak said:
Just as we use RowFilter, to choose a subset of rows , i wish to get s
subset of the columns. The workaround i could think of was to read the
DataTable again with only required columns eg - SELECT COL1 FROM DT1
where DT1 is the memory datatable.

1) Is it possible to apply a SELECT on a DataTable ?

2) How would one pick only the required columns after populating the
dataset ?

Regards.
Click to expand...
Click to expand...
 
I never use DataGrid (always a third party grid) as DataGrid is very limited
control.
Anyway, you might read this thread:
http://groups.google.com/group/micr...+group:*dotnet*&rnum=1&hl=sl#e8555f595f3bfd2e

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Chak said:
Thanks. Am using the Windows forms datagrid in 1.1

Regards,

Chak.


Miha Markic said:
Hi Chak,

Depends on the data consumer as this is a job for UI.
Which one are you using?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Chak said:
Just as we use RowFilter, to choose a subset of rows , i wish to get s
subset of the columns. The workaround i could think of was to read the
DataTable again with only required columns eg - SELECT COL1 FROM DT1
where DT1 is the memory datatable.

1) Is it possible to apply a SELECT on a DataTable ?

2) How would one pick only the required columns after populating the
dataset ?

Regards.
Click to expand...
Click to expand...
Click to expand...
 
With the datagrid you can filter the column to show by defined Column mapping
Then you mapp only columns you need to show

Chak said:
Thanks. Am using the Windows forms datagrid in 1.1

Regards,

Chak.


Miha Markic said:
Hi Chak,

Depends on the data consumer as this is a job for UI.
Which one are you using?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Chak said:
Just as we use RowFilter, to choose a subset of rows , i wish to get s
subset of the columns. The workaround i could think of was to read the
DataTable again with only required columns eg - SELECT COL1 FROM DT1
where DT1 is the memory datatable.

1) Is it possible to apply a SELECT on a DataTable ?

2) How would one pick only the required columns after populating the
dataset ?

Regards.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top