column count property cannot be set on a databound c#

Jyoti Jodha

9y5.8kWindows Forms

column count property cannot be set on a databound datagridview control c#

dataGridView1.ColumnCount = 7;

dataGridView1.Columns[0].HeaderText = "Product_ID";

dataGridView1.Columns[0].DataPropertyName = "Product_ID";

dataGridView1.Columns[0].Visible = false;

dataGridView1.Columns[1].HeaderText = "Name";

dataGridView1.Columns[1].DataPropertyName = "prodName";

dataGridView1.Columns[2].HeaderText = "Description";

dataGridView1.Columns[2].DataPropertyName = "_desc";

dataGridView1.Columns[3].HeaderText = "Tax_ID";

dataGridView1.Columns[3].DataPropertyName = "Tax_ID";

dataGridView1.Columns[3].Visible = false;

dataGridView1.Columns[4].HeaderText = "Unit_ID";

dataGridView1.Columns[4].DataPropertyName = "Unit_ID";

dataGridView1.Columns[4].Visible = false;

dataGridView1.Columns[5].HeaderText = "Tax";

dataGridView1.Columns[5].DataPropertyName = "Tax";

dataGridView1.Columns[6].HeaderText = "Unit";

dataGridView1.Columns[6].DataPropertyName = "UnitName"; dataGridView1.DataSource = dt;

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
try this
if you are calling these lines of code more than once then
before setting column property you have to make Gridview data source to null
as shown below
dataGridView1.DataSource = null;

dataGridView1.ColumnCount = 7;
dataGridView1.Columns[0].HeaderText = "Product_ID";
dataGridView1.Columns[0].DataPropertyName = "Product_ID";
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Name";
dataGridView1.Columns[1].DataPropertyName = "prodName";
dataGridView1.Columns[2].HeaderText = "Description";
dataGridView1.Columns[2].DataPropertyName = "_desc";
dataGridView1.Columns[3].HeaderText = "Tax_ID";
dataGridView1.Columns[3].DataPropertyName = "Tax_ID";
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].HeaderText = "Unit_ID";
dataGridView1.Columns[4].DataPropertyName = "Unit_ID";
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].HeaderText = "Tax";
dataGridView1.Columns[5].DataPropertyName = "Tax";
dataGridView1.Columns[6].HeaderText = "Unit";
dataGridView1.Columns[6].DataPropertyName = "UnitName"; dataGridView1.DataSource = dt;
+1
Rafnas T P9y ago
hi jyoti,

if you have set the columns in front end design than you have to remove it. because your creating collumns from c# code, if nomber of columns in design is less than code than also you will get this error.
+2
Vinay Singh9y ago
Hi check the below link

http://www.aspforums.net/Threads/203725/Error-ColumnCount-property-cannot-be-set-on-a-data-bound-DataGridView-control/

https://social.msdn.microsoft.com/Forums/en-US/887bb51a-e7e8-40c8-9ed0-c0aebe9d3fad/error-in-my-code-when-opening-new-boxes-in-datagridview?forum=csharpgeneral
+2
Ramesh Palanivel9y ago
Hi Jyothi,

Your question is not much clear. Kindly mention your exact requirement...
+2