How to Bind specific Columns of a datatable to a DataGridView?

Question

My DataTable has three columns fetched from a database, while I need to bind only two columns of it to a DataGridView. Can you please help me with it?

Answer 1

This may be useful

DataSet ds = new DataSet(); <-- Get data from Database here
DataTable dt = ds.Tables[0];
DataView view = new DataView(dt);
DataTable resultTable = view.ToTable(false, "Column1", 
"Column2","Column3","Column4","Column5","Column6");
dataGridView.DataSource = resultTable ;

Answer 2

Create the columns for the DataGridView yourself. Try something like this.

DataGridView dataGridView1 = new DataGridView();
BindingSource bindingSource1 = new BindingSource();

dataGridView1.ColumnCount = 2;

dataGridView1.Columns[0].Name = "Field1";
dataGridView1.Columns[0].DataPropertyName = "Field1";
dataGridView1.Columns[1].Name = "Field2";
dataGridView1.Columns[1].DataPropertyName = "Field2";

bindingSource1.DataSource = GetDataTable();
dataGridView1.DataSource = bindingSource1;

Answer 3

Add the column as answered above, and do not forget to set:

dataGridView1.AutoGenerateColumns = false;

Answer 4

This was asked a while ago, so you probably won't need this answer... Hopefully others will find it useful.

I had to do something similar, and I found that the simplest solution was to create a temporary copy of the table (in which your data is stored) and then to simply remove the column in question. For example:

DataTable temp = YourDataTable;
temp.Columns.Remove(temp.Columns[2]) // Will remove the third column for example
YourDataTable.DataSource = temp;
YourDataTable.DataBind();

I think this should do the trick!

Cheers!