Datagrid how to show Selected columns

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

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

VB Code:

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

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.

Cool:cool:

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