I have a datagridview(windows application) linked to a datatable. During save, it iterates through the datagrid and assigns value to one column in the datagrid( the rest of the columns are inputted by the user). After it has assigned the values, it then calls the datatable.getchanges() to get the updated, deleted and newly added rows and assigns the returned datatable to a temporary datatable.
The problem starts when I call the getchanges() method of the datatable. When I look at the data in the temporary datatable after the getchanges() method is called, in some rows of the column where I assigned the values programmatically are now gone(dbnull).
Any help is appreciated.