Idesigned the datagridview column headers using the IDE.

I then programatically connected the datagridview.datasource and column dataproperty names.

When I run the program I get two sets of columns.

How would I correct this?

Set AutoGenerateColumns property of the DataGridView to false before setting the DataSource for the DataGridView will avoid this problem. Something like this:

//Set the DataAdapter with the Datatable

this.daTransactions.Fill(this.dtTransactions);
this.dgv.AutoGenerateColumns = false;

//Set the BindingSource with the datatable

this.bsTransactions.DataSource = this.dtTransactions;

//Bind the navigator to the grid

this.dgv.DataSource = this.bsTransactions;

Set AutoGenerateColumns property of the DataGridView to false before setting the DataSource for the DataGridView will avoid this problem. Something like this:

//Set the DataAdapter with the Datatable

this.daTransactions.Fill(this.dtTransactions);
this.dgv.AutoGenerateColumns = false;

//Set the BindingSource with the datatable

this.bsTransactions.DataSource = this.dtTransactions;

//Bind the navigator to the grid

this.dgv.DataSource = this.bsTransactions;