Hello
A very basic ques about datagrid.

I pulled from SQL a 10 column data into dataset.
I only need to display 3 columns in datagrid.

I couldn't get this to work with dataview because you can only do rowfilter not column filter.

Then I tried to use PropertyBuilder of DataGrid to assign bound columns with data field of dataset.
When I created 3 columns of the 10 column dataset explicitly, why do the other 7 columns still load in datagrid. Is there a way for the datagrid not to load the other 7 columns?

The only way i got this to work to have stored procedure only pull 3 columns into dataset and use the entire dataset. But I don't want to do this cuz then I need more than 1 dataset.

All suggestions are welcome.

Check to see if AutoGenerateColumns is set to false
or
Try:

SELECT column_1, column_2, column_3 FROM table_name

Hey,

Yes, AutoGenerateColumns is probably set to true; you can tell because it would load the original 10 and additional 3. If it is doing this, that's your problem. That's the only thing I know that would generate the 10, because if it is set to false, you have to manually add the columns.

Brian

Got it Thanks