Can I access specific columns and create a dataset ?

Why don`t you create the SQL statement the way it will select columns you need? Mike

DataView is a data object. To see data use DataGrid etc. - visual objects. You can specify columns to see there. (See DataGridColumnStyle and TableStyles in help for Windows Forms etc.) It is not a good idea that we can't specify columns while creating DataView but it is Microsoft ... in another case it is useful. We can deal with invisible columns.

I just started looking at .NET, specifically C#. I read that DataViews can only filter rows not columns. In other words, I cannot filter what COLUMNS I want the user to see. Any ideas ? Am I missing something here ?