vb to C#

[Newbie]

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_pr oject_no,'US7AS CII') 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_NU MBER IN A VARIABLE CALLED "lpn"

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

[Daniel Groh]

Re: vb to C#

try to change the () to []

Regards

--

Atenciosamente,

Daniel Groh
CTF Technologies do Brasil Ltda.
Analista Programador
Fone: 11 3837-4203
E-mail: dgroh@ctf.com.b r
"Newbie" <Newbie@discuss ions.microsoft. com> escreveu na mensagem
news:6B8C8CAB-CC13-447D-B4B6-143448624125@mi crosoft.com...[color=blue]
>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_pr oject_no,'US7AS CII') 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_NU MBER IN A VARIABLE CALLED "lpn"
>
> lpn = lpn + 1
> Session("LPN") = lpn[/color]

[Eric Cadwell]

Re: vb to C#

lpn = rsLPN[0];

-Eric

[Wayne]

Re: vb to C#

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

"Newbie" <Newbie@discuss ions.microsoft. com> wrote in message
news:6B8C8CAB-CC13-447D-B4B6-143448624125@mi crosoft.com...[color=blue]
> I am converting a vb code to c#. I already converted most of the code[/color]
except[color=blue]
> 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_pr oject_no,'US7AS CII') 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_NU MBER IN A VARIABLE CALLED "lpn"
>
> lpn = lpn + 1
> Session("LPN") = lpn[/color]

[Newbie]

Re: vb to C#

I appreciate this, but something's not working right. Can u convert the
entire vb code? Thanks in advance.

sLPN = "SELECT Convert(last_pr oject_no,'US7AS CII') 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_NU MBER IN A VARIABLE CALLED "lpn"

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

-----------------------------------------------
"Eric Cadwell" wrote:
[color=blue]
> lpn = rsLPN[0];
>
> -Eric
>
>
>[/color]