Sorry , but if always I use integers , why vbnet and sql servers have other data types like float or decimal ? Is better to tell to remove this kind of data type from their products because we can use integers.
Ok , ok I see that you want to close this case as soon as possible.
But I think a forum is a place for discussion.
It's just a curiosity : Microsoft has included decimal in .net language programs and Sql server.
And why he not use this kind of data type in Excel ?
Or why don't use integers that you suggest ( and to multiply all the values by 100 , 1000 , 100000 .......) and as you think everything will be better.
I have the right to be against your opinion , you can be against to my opinion .. let's discuss. This is the forum.
The difficulty appears to be arising because you are comparing speed with accuracy - two things that by their very nature cannot be compared.
So you need to decide - do you want speed or accuracy?
If you really want more information regarding why floating point is used you will need to read up on computer hardware and architecture.
Basically computers are not decimal counting machines but binary counting machines. In order to maintain a decent processing speed numbers are stored as floating point,. The consequence is that repeated arithmetic operations on large numbers(numbers with many digits either side of the decimal point) can cause precision errors. Most people not running repeated arithmetic calculations with large numbers requiring a high degree of precision - Excel works perfectly well with floating point numbers.
“That which can be asserted without evidence, can be dismissed without evidence.”
I have created a program, ready to deploy. I will deploy this program from a CD.
As part of the install I want to create a desktop shortcut for the program.
I am using vb2010 express and I don’t know where to start.
I am iteration thought the row in order to insert/update/select.
How can I make Async call so it will be run faster
For Each myRow As DataRow In gobjImportDS.Tables(TABLENAME).Rows
.... If FindGIASPROVMSTR(myRow) > 0 Then
' if exists update
If GIASUpdateProviderMasterCommand(myRow) = True Then
Making it "async" doesn't make it run faster; it just makes it execute independently of the UI-thread. The simplest way to start something on a different thread is by queuing it in the ThreadPool[^].
Be carefull not to touch any UI-stuff from that new piece of code; it would crash the application, unless you wrap it nicely in an Invoke-pattern (to invoke the running of the next code on the UI-thread).
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
I'm having a problem on my code that's throwing me the following error:
'Class does not support Automation or does not support expected interface'
What I'm doing is, we have lot of ActiveX exe and we want to migrate them to .net, but as visual studio doesn't support ActiveX exe migration, I'm following this article ActiveX EXE Wrappers[^] I did one test project and after this worked I tried to migrate a working project.
So I was migrating my ActiveX exe to a Windows forms Application and I adde the following com class to my projec: