Re: Upgrading ASP w/SQLserver 2000 to ASP.NET w/ SQLserver 2005


ASP to ASP.NET?


Yeah dude. Plan on a complete port over, if you want to do it right.

If you dotNet code has references to ADODB, then you're barking up the wrong
tree.
(which is one of many bad things the upgrade wizards do)

I'll start you off with this tidbit.

NUMBER 1 THING NOT TO DO IN ASP.NET

Loop over recordsets and create html code.


Asp.Net has controls which you bind data.

asp:repeater
asp:GridView (2.0)
asp:dataGrid(1.1)

are examples.

DO NOT LOOP OVER RECORDSETS AND CREATE HTML CODE.

Good luck.




"Jeffrey" <cjeffwang@xxxxxxxxx> wrote in message
news:9FEC1972-BBEC-4004-93B9-08A09AA9E027@xxxxxxxxxxxxxxxx
I have some old ASP programs w/ SQLserver 2000 databases. Now I am
developing ASP.NET projects using VB 2005 and SQLserver 2005. What are
the
best procedures to develop and test the ASP.NET programs?

My main concerns are:
1. What do I need to test? VB 2005/ASP.NET with 2000 data? Migration of
2000 data to SQLserver 2005? VB 2005/ASP.NET with 2005 data?
2. How to minimize the transition time? What is the critical change for
the end users? SQLserver 2000 to 2005 or ASP to ASP.NET?


.

Relevant Pages

  • Re: how tgo compare datevalues in sqlserver, asp and Access
    ... the field dtmDate in a sqlserver table may contain a date like ... but as the dates formatted differently in sqlserver and asp I ... Dim mydate as date ...
    (comp.databases.ms-access)
  • Re: ASP.NET
    ... ASP net must be registered with IIS by running: ... The results of your asp page should be the same as your aspx. ... I downloaded and installed the Microsoft.NET Framework. ... Using the code in a kind of Scripting way inside the HTML code not ...
    (microsoft.public.dotnet.general)
  • Re: how to make FP 2002 form with FP extensions on server??
    ... For sending mail using CDONTS and ASP see ... > My web hosting company doesn't support FP extensions at this time. ... > the html code for making a simple submit type form in FP2002? ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: aspx variable replacement - runat=server
    ... having a runat="server" is that it creates a rich and capable server-side ... Instead of messing up your html code ... > With ASP: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: date format.
    ... a dd/mm/yy format. ... yyyy/mm/dd for the stored procedure to run. ... > The html code for my form is as follows ... > Not even sure if asp is needed to do this. ...
    (microsoft.public.inetserver.asp.db)