Hide columns in DataGrid

[Akshaya]

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!

[Bearnerd]

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

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

[Pasvorto]

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