CODEWITHSUNDEEP
vb.netvb.net-2010
kaneo
kaneo

Reputation: 27

VB.net incremented number concatenate with texbox value

I'm learning vb.net. I'm trying to create an incremental number that starts at 00000 and concatenate that number with a value from a textbox (eg. JH00001), then insert it into the database.

Please can someone kindly help me with this as I'm totaly new to vb.net.

Thank you all for your assistance in advance. And I'm sorry for my bad English.

Upvotes: 1

Views: 1160

Answers (4)

Basic
Basic

Reputation: 26766

I personally prefer using String.Format ...

For i = 0 to 1e6-1
    Dim FormattedString = String.Format("{0}{1:00000}", Textbox1.Text, i)
Next

Upvotes: 0

Abdusalam Ben Haj
Abdusalam Ben Haj

Reputation: 5433

Use D5 precision specifier to indicate that the number should be at least 5 digits including leading zeros:

Dim valueFromTextBox As String = "JH"
Dim value As String = ""

For i = 0 To 99

  value = valueFromTextBox & i.ToString("D5")

 'Insert value to database

Next

Check MSDN for more formatting methods

Upvotes: 0

Esselans
Esselans

Reputation: 1546

Dim number as Integer = 1
Dim text as String = textbox1.text &= number.toString().padLeft(5, "0"c)

Upvotes: 1

Blunderfest
Blunderfest

Reputation: 1854

A for loop should be what you need:

Something like:

Dim text As String = textbox1.text
Dim DBtext As String
For value As Integer = 0 To 5
    DBtext = text & value.ToString()
    'Insert anything else you need to do. Such as insert into DB.
Next

Just replace the 5 with however many times you need it to run.

Upvotes: 0

Related Questions