Can I access specific columns and create a dataset ?

Question

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 rows I want the user to see. Any ideas ? Am I missing something here ? Thanks

Administrator · Answer

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

Administrator · Answer

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.

Administrator · Answer

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 ?