Datagrid how to show Selected columns

[TonySaliba]

This is driving me nuts. I need to have a dataset binded to a datagrid. The data grid must not show all columns in the dataset but only a few. I will be adding records to the dataset in code and these should show in the datagrid, any kind of editing or adding is not allowed in the datagrid.

I tried using also dataviews, basically it would have been nice to have a dataview with a select statement on the dataset, thus selecting only the fields required, but it seems that this is not possible.

Any ideas are much appreciated.


Thanks

[Pirate]

simply do this to have dataset binded to datagrid :
after initialization of connection and filling data do this :

DataSet1.DataSource = dataset.Tables("your table")

[TonySaliba]

Thanks for the reply. Actually my problem was not to display a datagrid but to limit the number of columns. I did encounter the solution in various forums and issue was resolved.

[Pirate]

Cool

[RichardAtherton]

was that to set the column width to 0?, assuming you create a datagridstyle.