Displaying only selected data to datagrid

Question

Hello  can anyone pls help me in display only the required data from a dataset to a datagridview in vb.net I have a dataset with four fields like id name address phone but i need to display only the id name in the datagrid. I dont want to create a new dataset to hold only id name. After I display the datagrid once the user selects the particular row i need to return the id value from the selected row. Thanks.

David Carter · Answer

Select the DatagridView and open the properties. Goto Columns and click on the little ... button beside the word (Collection) Select the column Address and under Appearance make Visible = False. Same with Phone. D.

Geoff · Answer

The simplest way to achieve this is to just set the widths of the grid columns that you don't want to show to Zero