I have a data grid that is bound to a relationship of two tables in a dataset. The common field in the relationship is classId. When I view the data in the data grid I do not want to see the classId field but if I do not include the field in my select statement I get an error when I try to form the relationship. Is there anyway to hide a field/column in a data grid? ALong this line of questions, can the width of the data grid columns be dynamically set to fit the data in each column.

I can include code samples if needed.