dataset bind not all columns

[brenny]

Hi all

I'm using dataset and I'm filling datagrid with this dataset and my dataset
has 6 columns as "NAME","SURNAME","ADDRESS","TEL","BIRTHDAY" and "SCHOOL
NAME"

When I bind the dataset to datagrid,all columns are shown but I want to show
only three columns are "NAME","SURNAME" and "ADDRESS" and I don't want to
change dataset.

Dataset must have 6 columns but datagrid must have only 3 columns.

How can I accomplish this?

 

[Sahil Malik [MVP]]

Don't generate the columns from the dataset (this is a property on the
datagrid) - add the columns yourself (again this can be done using a
property), and databind the dataset as usual.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Cor Ligthert]

Brenny,

Use datagridcolumnstyle
http://msdn.microsoft.com/library/d...windowsformsdatagridcolumnstyleclasstopic.asp

I hope this helps,

Cor

 

[brenny]

I couldn't find any property about columns.
May you give an example about this topic.

Thanks.

 

[Sahil Malik [MVP]]

Is this a windows grid or a webforms grid?

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[brenny]

window grid..

 

[Sahil Malik [MVP]]

Many ways to skin this cat. Here is one way.

Create a strongly typed ds to mimic the structure of your dataset. Mark that
as the datasource for the window data grid. Edit columns -mark the ones you
don't wish to see as Visible = false. Run the app - databind - bingo !!

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/