Adam

Adam

  • NA
  • 27
  • 0

Urgent: Data Retrieval/Display Guidance

Mar 10 2010 5:29 AM


 Hi 
I'm generally looking for a bit of guidance to the scenario below as I am not sure of the best path to take.
I am creating an ASP.NET site which needs to meet the following requirements:
  • Will connect to a database
  • Database data needs to be displayed in a custom layout (so no table/grid layout)
  • Some of the displayed data will be read-only, so will only be displayed.  Other data will need the option to be edited by the user.
  • It is possible in the future that some of the read-only data will need to be updated to provide the ability to be edited by the user. 
  • Program functionality wise I need the ability to read certain values from the retrieved database data.
  • Site needs to be as secure as possible.

A simple example could be contact details and car parts.  The car parts will be read-only at present and the contact details will be the data that can be edited.  In the future it is possible that the car parts could be edited by the user.
The issues I am trying to decide on are:
Which will be the best method to implement which will allow the least amount of code change in the future when the read-only fields need to be edited:-
  • Should I go down the SQLDataSource route and bind these to a detailsview/datalist. (As I have only been using ASP for a limited time I'm not sure if I'm able to change the layout of these web controls enough using either CSS or the properties options to meet the display requirements of the site).
  • Should I go down the DataSet and TableAdapter route where I can read the data retrieved from the database and the set 'Text' properties of, for example, label controls.  I know this is probably the easiest method for reading certain values from the retrieved data.

I realise each method allows me to add in extra functionality in the future to allow the user to update/insert into the database, but I'm not sure which will be the best method for my requirements.
I am kind of leaning towards the DataSet/TableAdapter route, but feel I may not be aware to the full potential of the SQLDatasource method.  Any help or advise is much appreciated.
Thanks

Answers (2)