DataGrid column header

[heydyrtt]

Need to know how to get columnheaders from a db field, other than what my recordset is. I have a one table where the location_mask column is located, the data in this column is for locations and it like BLDG POD CELL FLR this is all in one column. And the grid data I'm retreiving is in a different table. How is possible to get the grid headers from this column?


Thanks


Heydyrtt

 

[Golom]

Data is in a different table ... ? I'm not sure what that means. A table that is not being retrieved?

There are two ways that you can set a coulmn header

The SQL

Select [BLDG POD CELL FLR] As [Location], ...

The Columns Collection

DataGrid1.Columns(1).Caption = "Location"