Converting String to integer in vb.net

Question

I have End Date in my DB table. On load I want to store it in an Integer variable. I want to use this month in a loop as an end of the loop.

objAcademicSession.Load()
Dim months as integer
months = objAcademicSession.EndDate

Now I want to end my loop on months.

please provide an example of what you have and what you want, otherwise no one will understand what you actually need and what's the problem — Keith Mifsud
– Keith Mifsud, Commented Jun 12, 2015 at 7:04
show how you want to use your month variable in the loop, show example of string in the EndDate property. Please help us to help you, instead of getting answers with If you have... or I assume... — Fabio
– Fabio, Commented Jun 12, 2015 at 14:46

Community · Accepted Answer · 2017-05-23 12:23:44Z

1

If your Variable has the Data Type: "Date/DateTime", then you can just use this:

months = objAcademicSession.EndDate.month

If your Variable has the Data Type: "String", then you can use:

months = Convert.toInt32(objAcademicSession.EndDate)

And if you need to "split" the String because it contains the full date and you just need the month, look at this: "VB.NET - Split String"

You can just "cut" the needed part out. But just if you have a date like this: "2014/4/4 16:30:19". Otherwise use the Code above.

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Jun 12, 2015 at 6:53

Sonorpearl

578 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Shafay Over a year ago

No i want to use this Variable for my FOR LOOP. So i need this to be an integer

Sonorpearl Over a year ago

.month is a Function that provides you with the month number as an Integer. -- How does your objAcademicSession.EndDate look like? -- What Data Type is it? -- Please provide more Informations! -- And what do you even want to process?

Shafay Over a year ago

Check my Question Again @sonorpearl

Sonorpearl Over a year ago

The Problem still remains: What Data Type is your objAcademicSession.EndDate? -- How does your DB Structure look like? -- And @Shafay: .month Should do the job.

Shafay Over a year ago

objAcademicSession.EndDate is of type String

|

Idle_Mind · Accepted Answer · 2015-06-12 07:15:47Z

0

objAcademicSession.EndDate is of type String ... I want to use this month in a loop as an end of the loop.

Assuming EndDate is "1" thru "12":

objAcademicSession.Load()
Dim months As Integer
If Integer.TryParse(objAcademicSession.EndDate, months) Then
    For i As Integer = 1 To months
        Debug.Print(i)
    Next
End If

If you have full dates in EndDate, please provide us with examples of what they might look like.

answered Jun 12, 2015 at 7:15

Idle_Mind

39.3k3 gold badges31 silver badges40 bronze badges

Collectives™ on Stack Overflow

Converting String to integer in vb.net

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related