I have four different gridviews on a page. Plus a fifth gridview on the bottom.
The first four hold data from the database entered by the user. This is always a currency value.
I need to append each value with A), B), C) etc, and keep it in order so the first gridview always starts with A) and it goes down from there. If one value gets added/removed, all the other values must be updated so there are no gaps i.e. A) B) D). In this instance D) must be updated to C), regardless of which gridview it's in.
The fifth gridview will have the references A) B) C) etc along with another field associated with each record in all the gridviews.
I started off creating an enumeration, but I'm not sure of the best way to append these values without re-hitting the database for each gridview whenever another one gets changed.
Should I store a generic list for each gridview in memory (session) and update that when another gridview gets modified? That would limit my database hits to only be for the gridview that is modified and the others could be updated in memory.
Any thoughts or questions based on my description?
View Complete Post