Hello, Thanks for indicating the way. Actual code is tblMaster.Columns("Id").ColumnMapping = MappingType.Hidden tblMaster.Columns("IsBillable").ColumnMapping = MappingType.Hidden where "tblMaster" is datatable, it does work and seems to be correct way of doing this. Now I am trying to see how the hidden columns will be updated when foreign key values change due to change in name/description of foreign key or when a new record is added. I will post the concerned code when I check it thoroughly. thanks once again.

thanks, Madhav

kindly give the soluton you found.

thanks, Madhav

I am using vb.net 1.1 for desktop application. While displaying contents of a datatable / dataview in a datagrid, I wish to suppress some columns (foreign keys, few admin fields) which user is not concerned with. how do I do it?

thanks, Madhav

Thanks a lot. We misssed on SelectedValue property. It's working fine now. :)

thanks, Madhav

With the help from Code Project site I have been successful in placeing various controls in grid. Now it has two three shortcomings (!) as of now. 1. If I use datatable as datasource to combobox placed in datagrid, assign "Name" and "Id" as Display and Value member respectively, In "SelectedValueChange" event it returns "Name" as Displaymember and "Id" as Valuemember instead of actual values. The combobox shows proper values of "Name". 2. I tried to assign values of datagrid cell to datatable row element as follows but it did not work... table.rows(1).Itemarray(1) = dgGrid(CurrentRowIndex,3) above line is indicative, actual code has proper names for table, grid, etc. also put in a loop to iterate. any solution to these issues are welcome.

thanks, Madhav