I have a data grid, and a multiline textbox, and a submit button. The user (students) type SQL commandsw into the textbox, and click the button to runt he SQL selection and fill the grid. Works fine, except, the columnh headers persist from one selection to the next, and the next ... i.e., if the first selection is SELECT COMPANYNAME, CITY from CUSTOMERS ... and the next selection is "SELECT CONTACTNAME, STATE from CUSTOMERS" ... the grid retains the COMPANYNAME and CITY column headers, filling the columns with nuls. Each new column sticks as new SELECTS add stil more columns.
I've tried datagrid.clear and can't find any method of property that seems to reonfigure the headers. Can anyone help?
Thanks,
Stephen
Joplin, MO