You need to change the DataAdapter's update, delete, insert, and select queries and add another parameter for the new field. This is probably not a good idea.
Let me ask you this -- are you using a typed dataset or one created in code?
I use created in code, in memory.
Update/Delete working fine, because I don't have to add any column or so on those. Whereas I have to add number of columns to the already populated datatable and insert them all as new (RowStateAdded). It inserts only the ones which have already been populated. My ınsert statement includes the newly defined columns. Apparently I fail to define new columns and attach them somehow to datatable. I have tried many possibilities but no result
I think I solved it, it is uppercase/lowercase problem. When I define the new columns I defined them lowercase whereas in insertcommand they are uppercase. So newly added columns also inserted into datasource.
Those concepts however did not settle very clear in my mind
1- when I adapter.Update the datasource fields have to be uppercase, otherwise it does not work. Is there a parameter I have to define so that it accepts anything(upper or lowercase)
2- how do I reflect changes to datagridview after I add columns and enter values into them
3- If I enter values to the grid where those additional columns already defined in the formDesigner but not in the datatable, how can I reflect datagirdview to datatable
4- how should I use binding, beginedit and endedit in these cases
Hi. so this is actually a continuation from another question of mineHere but i was advised to start a new thread as the original question was already answered.
This is the result of previous question answered :
code for the listbox - datagridview interaction
At the top of the code ...
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
Private Sub btn_addline_Click(ByVal ...