How to add new row(s) in a databound datagridview in C# WinA

Mayank Jani

Hiii Members,

I am working on a C# WinApp. In a form there are two ComboBoxes and one DataGridView. the first ComboBox contains customer names, the second ComboBox contains products (fruits, vegitables, house holds etc). I have wrote a code that some customers have pre-added products saved in a DataTable so, when I select the customer's name from ComboBox, the pre-saved products automatically loads into the DataGridView.

problem is when I try to add a new product for the customer, system throws error, "ColumnCount property cannot be set on a data-bound DataGridView control."

when remove the ColumnCount property, it throws another error, "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound."

I have googled many times but no solution working for me. DataGridView.DataSource = null; will not work because I want to add more row in existing (pre-loaded) list.

Please show me anyway to add a row in a databound datagridview C# WinApp.

Thanks

Mayank Jani

7 Replies

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

Mayank Jani7y ago
Hi Amit,
Please see the attached images and if you want I will send the data tables too.
I think the problem is with DataGridView. All errors occure at DGV, I might be wrong if I do not understand the error.
Please go thru the numbers of examples 1, 2, 3...

Thanks..
Amit Gupta7y ago
That's what I am saying, as you have binded datatable to combobox then you have to use var row =DataTable.NewRow(); row["Item"]= 'sugar"; Datatay.Rows.Add(row); When you do this, combobox will update the items automatically.
Mayank Jani7y ago
Hii Amit Mohanty,
Thanks for your reply. It throws error, 'Input string is not in a correct format.' I have to alter the quary as '[ProdTotal]' instead of ''[ProdTotal]. This also throws error.

Hii Amit Gupta,

Thanks for your reply but, I really do not understand what you are trying to say...
I am trying to load values from (Products)ComboBox into (Order)GridView.
the problem occures when the GridView has already some rows which are filled from the Customer ComboBox.

let me make it clear with an example, suppose, I am a seller of groceries and I have some customers. There are some customers who are buying some perticular items regularly. so, I have saved the items in a seperate table with their name or IDs with the items. Now when I select a customer's name from customers list (cmbCustomer), the system loads the perticular items (toothpaste, salt, sugar etc) from the table into the DataGridView.
Now the problem starts here, if the customer want to add an extra item (say, Maggie), I will add the same from products list (cmbProducts) at this time system throws error for the data bound DGV.
Is there any way to 'disconnect' the dataset after load the data table once and able to append row?

Hope you understood.

Thanks
Amit Gupta7y ago
Hey, please be generally aware that when you are binding datasource (like DataTable) then add/remove items there only else you use combobox.Items.Add..)
Amit Mohanty7y ago
Hey Mayank change your select query in cmbProduct_KeyUp like
Select ProdName,ProdQty,ProdPrice,''[ProdTotal] From Products Where ProdName....
Mayank Jani7y ago
Hii Piyush,

Sorry for late reply...
Please find the zip file for code.
Piyush Pansuriya7y ago
Hi mayank, can you please share your code?
Which process you are doing exectly, need to understand.