Hide columns in DataGrid

Dear friends,

I have 5 fields in Table Items.I created DataGrid to view the table.
I have 5 cols. as follows.

code,name,uom,desc and stock.

But I don't want to display all the columns.I want to display only
code,name and stock.How to hide other cols, Please help me to do!

Why don't you just query the needed column when opening a recordset?

VB Code:

sSql = "SELECT code,name,stock FROM [TABLE]"
    rec.Open sSql, con, adOpenDynamic, adLockOptimistic
    rec.CursorLocation = adUseClient
    Set DataGrid1.DataSource = rec

I have used flexgrids and just set the col width to 0. Never tried it with a data grid.