converting vb to c#

[Guest]

I'm having trouble converting the following, pls. help. Thanks in advance.

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") = lpn

 

[W.G. Ryan eMVP]

Are you using ADO.NET objects or are you using the ADO library?

 

[Guest]

Code was written by someone else. Have no idea if its ado.net or ado lib.,
but I think it's not ado.net bec. the app. is not .net.

 

[Guest]

This might gives us a clue: The following appears at the start of the file.

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