vb to C#

[Guest]

I am converting a vb code to c#. I already converted most of the code except
for:

lpn = rsLPN(0)

How do you convert the above code. It's probably easy but I cant figure it
out. The entire code follows:

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

 

[Daniel Groh]

try to change the () to []

Regards

--

Atenciosamente,

Daniel Groh
CTF Technologies do Brasil Ltda.
Analista Programador
Fone: 11 3837-4203
E-mail: (e-mail address removed)

 

[Eric Cadwell]

lpn = rsLPN[0];

-Eric

 

[Wayne]

assuming the below is VB.net try this link:

http://www.developerfusion.com/utilities/convertvbtocsharp.aspx

--
Thanks
Wayne Sepega
Jacksonville, Fl

Enterprise Library Configuration Console Module Generator
http://workspaces.gotdotnet.com/elccmg

"When a man sits with a pretty girl for an hour, it seems like a minute. But
let him sit on a hot stove for a minute and it's longer than any hour.
That's relativity." - Albert Einstein

 

[Guest]

I appreciate this, but something's not working right. Can u convert the
entire vb code? 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