datagrid cell updates
-
I have a datagrid and a dataset...and naturally the source of the datagrid is a table in the dataset. When I type a value into one column, I would like to update the value of another column. For instance, if I was keeping track of items purchased in my table, and I enter the Quantity and Price in respective cells, I would like the next cell to calculate this value and show immediately. I have an expression string to do this in my dataset table, but the datagrid doesn't seem to add the row until I have physically scrolled through all of the columns in the row...so the Total cell doesn't get updated until I actually navigate through it and into the next row. Can I put an expression on the column in my datagrid somehow, or manually do the calculation and set the value into the correct cell? Thanks for the help on this. :)
-
I have a datagrid and a dataset...and naturally the source of the datagrid is a table in the dataset. When I type a value into one column, I would like to update the value of another column. For instance, if I was keeping track of items purchased in my table, and I enter the Quantity and Price in respective cells, I would like the next cell to calculate this value and show immediately. I have an expression string to do this in my dataset table, but the datagrid doesn't seem to add the row until I have physically scrolled through all of the columns in the row...so the Total cell doesn't get updated until I actually navigate through it and into the next row. Can I put an expression on the column in my datagrid somehow, or manually do the calculation and set the value into the correct cell? Thanks for the help on this. :)