473,395 Members | 1,977 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

converting vb to c#

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
Nov 17 '05 #1
3 1162
Are you using ADO.NET objects or are you using the ADO library?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Newbie" <Ne****@discussions.microsoft.com> wrote in message
news:DE**********************************@microsof t.com...
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

Nov 17 '05 #2
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.

"W.G. Ryan eMVP" wrote:
Are you using ADO.NET objects or are you using the ADO library?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Newbie" <Ne****@discussions.microsoft.com> wrote in message
news:DE**********************************@microsof t.com...
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


Nov 17 '05 #3
This might gives us a clue: The following appears at the start of the file.

<!-- #INCLUDE VIRTUAL="/msado/adovbs.inc" -->
"W.G. Ryan eMVP" wrote:
Are you using ADO.NET objects or are you using the ADO library?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Newbie" <Ne****@discussions.microsoft.com> wrote in message
news:DE**********************************@microsof t.com...
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


Nov 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: mustafa | last post by:
Dear sir , I have built my application in visual basic 6.0 and crystal Report8.5 , Now i migrated my application to VB.net using the upgrade wizard.My visual basic form is upgraded to vb.net...
29
by: Armand Karlsen | last post by:
I have a website ( http://www.zen62775.zen.co.uk ) that I made HTML 4.01 Transitional and CSS compliant, and I'm thinking of converting it into XHTML to learn a little about it. Which XHTML variant...
8
by: prabha | last post by:
Hello Everybody, I have to conert the word doc to multiple html files,according to the templates in the word doc. I had converted the word to xml.Also through Exsl ,had finished the multiple...
5
by: Robert | last post by:
I have a series of web applications (configured as separate applications) on a server. There is a main application at the root and then several virtual directories that are independant...
3
by: Mary | last post by:
Hi, Does anyone know of any software out there that would convert an application written in VBScript to either VB.NET or C#/C++ quite quickly for me, or will I have to re-write the application...
2
by: Map Reader | last post by:
Greetings, I am converting an old VB6 application to use .NET. One of the old controls loads icons from the disk and displays them. However, the transparent color turns to blue somewhere in the...
12
by: Frederik Vanderhaeghe | last post by:
Hi, I have a problem converting text to a double. Why doesn't the code work: If Not (txtdocbedrag.Text = "") Then Select Case ddlBedrag.SelectedIndex Case 0 Case 1
7
by: Tor Aadnevik | last post by:
Hi, I have a problem converting values from Single to double. eg. When the Single value 12.19 is converted to double, the result is 12.1899995803833. Anyone know how to avoid this? Regards...
4
by: gg9h0st | last post by:
i'm a newbie studying php. i was into array part on tutorial and it says i'll get an array having keys that from member variable's name by converting an object to array. i guessed "i can...
2
by: shenanwei | last post by:
DB2 V8.2 on AIX, type II index is created. I see this from deadlock event monitor. 5) Deadlocked Connection ... Participant no.: 2 Lock wait start time: 09/18/2006 23:04:09.911774 .........
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.