I've managed to figure out how to create tables in a dataset, fill them with data, and link one of those tables to be displayed in a DataGridView. It works great when the selectionmode is by row, row header, or cell, but unfortunately for this project I'd like the user to select one column at a time. If I set the selectionmode property to ColumnHeaderSelect or FullColumnSelect nothing displays in the DataGridView anymore, it's just a grey rectangle. Does anyone have any idea why this might be happening?

In case anyone's curious, I finally found the solution to this problem here. Basically, every time you add a column, you have to switch the selectionmode to cellselect, add the column, then switch back to columnheaderselect.