locked
web form - app design question RRS feed

  • Question

  • User-2132746437 posted

    I'm working on an app that connects to Oracle and it will have to show data from 260 tables (as of now). These tables can be read only and shown in a gridview, or a user can update them based on their role, it can a gridview with update, or a listview/formview depending on how much data will have to be shown. The grids will have a checkbox for some tables, date fields for some tables, and different formatting for just about every table.

     

    So, my question is, would it be easier to create on page that can use a gridview and format it for each table? if so, how can I accomplish this?

     

    Or, due to each table has different data output requirments, does it make sense to create a page for each table.

     

    I'm looking for something that won't hurt performance of the web app, not be a nightmare to maintain, however, be simple enough to add new tables as they are requested to be created.

     

    any suggestions is greatly appreciated.

     

    Friday, May 28, 2010 11:29 AM

Answers

All replies

  • User-863835478 posted

    How are the tables going to show? All 260 at once or some of the 260? The first thing we need to know is which tables to show and what format to apply. How can that be determined?

    Friday, May 28, 2010 1:31 PM
  • User-2132746437 posted

    I have a form that list all 260 tables, the user can then click on one of the table names and that will take them to details page for that table, and that page will list all of the data that is within that table.

     

     

    Friday, May 28, 2010 1:33 PM
  • User-2080168305 posted

    Well u can create the format of gridview dynamically/Runtime.

    HOW TO: Build a dynamic gridView at runtime

    http://www.codeproject.com/KB/aspnet/How_to_create_custom_boun.aspx

    http://forums.asp.net/t/1020163.aspx

    http://forums.asp.net/t/1518747.aspx

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 28, 2010 1:53 PM
  • User-525215917 posted

    If you REALLY don't have any business rules to follow besides ones that are forced on database level you may try out ASP.NET Dynamic Data. It need a little bit modeling work but if you have simple data model /users select data by table) you should be able to live with Dynamic Data pretty well.

    Saturday, May 29, 2010 1:36 PM
  • User-2132746437 posted

    We can't get that working with Oracle, we did a test against an SQL db and it worked somewhat, but it wouldn't work at all against my Oracle database 

    Wednesday, June 2, 2010 2:04 PM