Hi there. I'm creating a ASP.NET site in VS2008 (using VB), which is used
similarly to a stock exchange application, only with less data to handle each
My problem consists of choosing the right path, between having my data
(readonly) in XML files for my users, or retrieving the values from the DB,
in each postback.
The data is pretty static, which means after my admin users insert them,
there are very rare changes. Then, the operators read them, so they produce
other data for DB insertion. There is no statistical usage of the readonly
data. In fact, they are deleted every three days, so the new readonly data
are setup by the admins.
The path i'm thinking of choosing, is using the XML storage (although new to
using XML), and display the data inside gridview controls, but I have two
fears, so I need some help by more experienced programmers in such a case:
F1. What about the file locking issue when the admin is trying to recreate
the XML file after doing some changes (although rare as I said)? I have a lot
of users wanting to read data.
F2. Is it possible to update a couple of specific nodes in the XML file
(along with their subelement values or attributes), based on a DB SELECT? I
mean, a certain node branch, should be updated everytime some reference data
in the DB changes, when updating the final XML file. That is, in the sample
I want to update the data inside <OddsGroup1> based on a DB select from a
reference table (Select A1,AX,A2 from ...). How is it done in ASP.NET (VB)?