Hi there,
Im trying to find out how to create a front end ASP page that connects to
a
SQL server and retrieves a whole bunch of data. The page needs to be able
to
update, delete or add new records. The form itself will be showing
information about computer hardware on our domain ie ram, hd size, id tag,
os etc and I have about 200 computers sitting in a single table in SQL, so
not too much data to work with.
I was just wandering on the best approach to handling the data? Ive found
some samples on recordsets and datasets - also samples on using sqlCommand
and sqlDataReader. Id like to make it as quick access as possible so
thought
of using the sqldatareader, but if I need to change or add data then
sqldatareader might not be the optimal choice. On the other hand if Im
using
datasets and datables and the users not always going to be modifyiing the
data then I thought it would be overboard using this option. The upside I
gues to using this access method is I can get a one time snapshot of that
data and then when Ive finished doing what I need to do it updates at the
end. But is this way slow? And is it the easiest?
Can anyone give me advice on what the best access method would be? Im
probably going to have about 3 forms - a find page which shows results on
the same page, an add page to add data, and a display page to display the
selected computer.
Thanks for any suggestions,
Grant
by the way Im using C#, SQL 2000 dev on XP.
|
