Welcome to weblogs.com.pk Sign in | Join | Help

Classic ASP to ASP.NET: Master Detail (Part I)

While revisiting one of the classic ASP site, I found a dynamic web-page having the code whose pseudo code is given below, this page basically list the dealer list based on the selected city and area.

 

rsDealers = getDealers(request(“City”), request(“Area”));

do until rsDealers.eof

      write rs(“Company”)

      write rs(“Address”)

      rsPhones = getPhones(rsDealers(“dealerid”));

      do until rsPhone.eof

            write rsPhones(“Phone”);

            rsPhones.movenext();

      loop

      rsEmails = getEmails(rsDealers(“dealerid”));

      do until rsEmails.eof

            write rsEmails(“email”);

            rsEmails.movenext();

      loop

      rsDealers.movenext();

loop

 

The database schema:

 

Its simply, I am listing here for the reference:

 

Dealers table has the dealerid (primary key), company, address information

Phones and Emails table has dealerid as foreign key.

 

This is a very typical Classic ASP approach. We now need to re-write this thing in Asp.Net, where we have much richer web-form infra-structure. What are your recommendations?

 

Look for my next post.

Published Monday, October 11, 2004 4:04 PM by khurram
Filed under:

Comments

No Comments

New Comments to this post are disabled