vb to c#

[Guest]

Hello!

I need help in converting the vb code below to c#. Thanks in advance.

' SELECT THE LAST_PROJECT NUMBER FROM PA_CONTROL
sLPN = "SELECT Convert(last_project_no,'US7ASCII') FROM pa_control FOR
UPDATE "

Set rsLPN = db.Execute (sLPN)

While not rsLPN.EOF
Session("LPN")=""
lpn = rsLPN(0)

rsLPN.MoveNext
wend
' STORE LAST_PROJECT_NUMBER IN A VARIABLE CALLED "lpn"

lpn = lpn + 1
Session("LPN") = lp

This appears at the start of the file:

<!-- #INCLUDE VIRTUAL="/msado/adovbs.inc" -->

 

[Peter van der Goes]

Hello!

I need help in converting the vb code below to c#. Thanks in advance.

' SELECT THE LAST_PROJECT NUMBER FROM PA_CONTROL
sLPN = "SELECT Convert(last_project_no,'US7ASCII') FROM pa_control FOR
UPDATE "

Set rsLPN = db.Execute (sLPN)

While not rsLPN.EOF
Session("LPN")=""
lpn = rsLPN(0)

rsLPN.MoveNext
wend
' STORE LAST_PROJECT_NUMBER IN A VARIABLE CALLED "lpn"

lpn = lpn + 1
Session("LPN") = lp

This appears at the start of the file:

<!-- #INCLUDE VIRTUAL="/msado/adovbs.inc" -->

Conversion from ASP to ASP.NET?
Were you looking to just convert from VB to C#, still using ADO, or convert
the database interaction technology to ADO.NET?

 

[Guest]

yes, it is being converted from asp to asp.net, convertion from VB to C#
only , still using ADO.