I am developing a windows form in VS 2002 that contains a datagrid which is bound to a dataset and sqldataadapter that has a select statement that returns a result set from across multiple tables. What I am having trouble with is, is displaying the column headers with "nice" names rather than the database column name and having extra fields, not part of my select list appearing in the datagrid column list, specifically id columns that point to lookup tables for which I only want the description displayed.
How do I get the datagrid to display the "nice" names i want for display and to only show the columns I want displayed?
How do I get the datagrid to display the "nice" names i want for display and to only show the columns I want displayed?
