Search:

I am trying to add a simple "request for information" on a website. The user inputs fort, last name, and email address they get a message back with a link to information they can download. I have...

I will run it with larger datable tomorrow and see if i get exceptions

I know you said the UI thread knows how many records have been processed I struggled obviously to figure out how to get...

I am doing one table at a time look at post #23
I added the i += 1 in the foreach statement so i had an integer to pass to get a record count into my label in my background worker progress changed

I have not tested on a large DataTable but ran it on a 50 record one and it ran flawlessly
Perhaps on a larger Table it might cause confusion? I will run it and let you know

I came up with this a a solution. Not sure its the best way to do it but I can't see why not


Private Sub BackgroundWorker4_DoWork(ByVal sender As Object, ByVal e As...

That was an excellent guess. I was setting the Max value to number of rows with Null value while in the code I was checking each row for null value. Thank you



Private Sub...

So here is what I arrived at

This is in my Parallel.For Each
BackgroundWorker3.ReportProgress(0, "Records Retrieved")

This is in BGW Progress Changed
Label1.Visible = True
...

I understand the logic I don't understand how to get the variable (if that is the correct word) to get the progress

In my previous way I could see that "i" was the next step that was completed...

You confuse an individual's actual ability with your expectations of what you think their ability should be. Believe what you want but I have been working on this all-day (literally). You do this...

Trust me by the time I post something here I have thought about it considerably and google searched. So if I post a question here it is because I am stuck. Posting a question is NOT my first method...

Gotcha
How would you recommend reporting progress when using the Parallel.ForEach?

I was doing it this way

BackgroundWorker3.ReportProgress(i, i & " " & "Records Processed")

but not sure...

Do I follow the same for both For Each statements?

I followed the non-LINQ code and I placed it in a background worker do work sub. It is working but starts fast then slows down. I went back to re-read a comment you made about GetAddress being...

Thank you

p.s. no sure why I was storing the LAT and LONG as strings I needed them as integers later
Thanks for pointing that out

Thanks for the help. It is actually looping through two separate Data Tables. The "For each" line in my original code posted was redundant as you pointed out.
I will look into the Parallel For each...

It loops through a data table and if a longitude or latitude value is missing it retrieves the value via a Google GEO COde API call. I saw an obvious mistake moments after posting my question.
This...

I am looking for some help in making this code better it works but it seems to be awfully slow. I am VB hobbyist and I suspect it is not written well.


Public Function GEOCode() As Boolean


...

I was targeting the incorrect framework
Thank you for your help

You are right if I create a new Winforms project I don't need to add any references
My project was originally created on VS 2008 it upgraded when I opened it in VS 2017 so obviously something is...

You are right if I create a new Winforms project I don't need to add any references
My project was originally created on VS 2008 it upgraded when I opened it in VS 2017 so obviously something is...

It says
MS Visual Studio Express 2017
Microsoft.NET Framework Version 4.7

It says
MS Visual Studio Express 2017
Microsoft.NET Framework Version 4.7

I dont see that reference ?

167009

Yes first thing I did was add the System.Net

Thanks I am getting an error URLEncode is not a member of WebUtility

I am using the following code to obtain GeoCode coordinates.


Private Function GetAddress(ByVal StreetAddress As String, ByVal city As String, ByVal state As String, ByVal zip As String) As...

There are several issues progress bar is one I am also using Google Map API to retrieve missing Longitude and Latitude fields in my data and that does not be working as smoothly as before
I...

I installed VB 2008 Express and ran the project from there. The progress bar is not visible at all

It is a simple program that reads a text file into a datagridview and then loops through the...

I made a small program years ago using VB 2008 express and ran it on XP and Win 7 Machines
6 years later I decided to try and run the program on windows 10 64 bit and having several issues
In...