dcsimg
www.webdeveloper.com
Results 1 to 3 of 3

Thread: SQL Amateur- Call, Edit, Add New, specific tables

  1. #1
    Join Date
    Apr 2004
    Posts
    27

    SQL Amateur- Call, Edit, Add New, specific tables

    I have a SQL database with numerous tables linked to my site to generate its content. My next move forward is to create a web-based interface to have direct interactions over these tables. In theory, I would like 1 routine to call and display a table via an AutoPostBack Dropdown List and routines for Edit, Update, Delete, and Add New. The routine themselves are somewhat easy to implement, however, how can you enable the code to intelligently detect the current ACTIVE table and Edit, Update, Delete, and Add New to the current Table? Along the same lines how do you automatically display a table based on a dropdown selection WITHOUT using long-winded code such as Select Cases or If and Then statements combined with Response.Redirect and Querystrings as this was the only solution I have found and may have overlooked the obvious during my 'research'. Any assistance with concepts or actual code will be greatly appreciated!

  2. #2
    Join Date
    Nov 2003
    Posts
    655
    Store the table names in the dropdown. Plug the selected value from the dropdown into a querystring where the table name should go. No IFs ANDs or ORs

    Obviously, you'll want tight security on the page.

  3. #3
    Join Date
    Apr 2004
    Posts
    27

    ...?

    I tried that method but using an ASP derived variable (converted to String) simply DOES NOT work even when the resultant is the exact same...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles