in .NET, when I add two SqlDecimals, like so:
[Code]...
then s3 has precision 2, whereas both s1 and s2 have precision 1. This seems odd, especially as the documentation states that the return value of the addition operator is "A new SqlDecimal structure whose Value property contains the sum." I.e. according to the documentation, addition should not change the precision.
I am trying to do a simple summary of table data using a LINQ query.a regular SQL Query looks like:[code]This query works fine and returns the correct results.[code]This LINQ query returns the incorrect results some of the time. Off by .01 in most cases.The "value" column is of type Numeric (12,2) in the database.Now when I show the values from the Sum in a msgbox I get extra precision and thus incorrect results as my end result because of rounding.For example I get 835.18 + 54.62 = 889.80960 from the above LINQ query.I am running Visual Studio 2008 9.0.30729.1 SP on Vista 64Bit with .NET 3.5 SP1.
View 3 RepliesI have a form based application that works without issue at 100% (Windows 7), but one increases it to 125%, everything goes awry. Now, I know to set the form AutoScaleMode to DPI, which alleviates some of the issues, but some controls are cut off because of the form size.I know I can set 'AutoSize = True' on the form as well, but this gives unintended results and doesn't allow the user to resize the form as needed.What is the best way to handle DPI increases? Should I get the user's DPI and manually draw all the controls based on their DPI setting?
View 4 RepliesI have a simple question that most could probably answer. I have a button that when it is clicked it transfers information from that form to a microsoft word doc. Now what I want to do is everytime that button is clicked it creates a number that is displayed on the word doc. So this is how it would go:
first click- it would show a number 1 on the invoice.
second click- it would show a number 2 on the invoice.
This would continue as long as the program is used.
I need a tutorial for Visual Basic 2010 or 2008 where I can learn how to make a program increases or decreases the size...
View 6 RepliesI have a fairly small double and a fairly large double. When I divide the large one by the small one and display it with Console.WriteLine, it always shows exponential notation. Can I display the non exponential notation form?
View 2 RepliesOk i have a progress bar that increases when a download starts to finish. The once its compleate the next part of the script starts.
After all the script has finished, around 30 seconds. It starts the full process again but atm it wont start again as the progressbar is still complete.
I have tryed adding
ProgressBar1.Value = 0
To the end of the script to set its value back befor the script starts again but that dont work either :/
How would i get the progress bar to go back to its orginal state so that it can start all over again.
VB CODE
Dim Gimagepath As String
Gimagepath = System.IO.Directory.GetCurrentDirectory() + "udimage.jpg"
Dim Gimage As String
[Code].....
I'm trying to fix a problem that is just killing my program's efficiency. When I run it, it starts out at maybe 10M of RAM, but it gradually increases. Within 20 minutes, it can get up to 700M of RAM. Now, when the program is restarted, all of this goes away and starts anew, but restarting the program every so often is a very loose solution. Here's what my program does: there's an array in which many (anywhere from 500-4000 or so) links are placed. I have a webbrowser that navigates to each of these and does an action on them, then moves to the next page. For example: [Code]
And all of the actions work perfectly, but the memory exponentially increases, resulting in a crash if left on for too long. I've searched Google and all I've found is that that's not the actual usage, and that if you just minimize it and maximize it again it will go down, but it did not when I tried it. Why is the memory increasing so much like that, and is there any way to fix it?
I check the memory usage of my project from task manager, It always increases when I open forms but doesnt decrease when I close them. So the memory usage is getting bigger and bigger...
View 8 RepliesI am working on an application that allow the user to store data as numbers.These numbers are later on used for calculation. The number can be of any type and are saved as string. The problem is when they are used for calculation how can understand when it is better to treat them as doubles and when as decimals?
View 9 RepliesI recently made a change to the code within a loop in my code, and now when I run the code through Visual Studio 2010 Express, the loop runs about 10x slower than the previous loop.I did not make any significant changes (to my knowledge) to the code within the loop.I made the change so that the loop could handle various conditions I imposed in another section of the code.I know that it is this loop that is slowing everything down because I report the loop progress on my form.[code]I feel like my changed code should run better, but it doesn't.I know that my code is not written very efficiently (and feel free to comment on ways to improve it), but my main concern is the significant increase in computation time that resulted from my changes.The loop above is the main block of code within the Sub, which is run via a thread.In my tests, it is the only thread running at that time.Everything works, and the computation yields the correct result, but takes 10x longer than previously. Additionally, the number of iterations does not increase.So the new code isn't iterating excessively, it is simply taking much longer to compute within each iteration.
View 19 RepliesI am currently working a piece of code which needs to send an attachment in the
email it generates. The attachment is a PDF document. Due to requirements I am
unable to save the PDF and send it, so I have had to create a memory stream attachment.
The issue I have with this is that the file size is _500KB. However save the file on my machine and it is around 370KB.
This increase in file size is unacceptable. has anyone come across this issue before? If so how have they got round the problem.
Below is the section of code.
Dim memStream As System.IO.MemoryStream = Nothing
'assign number to the PDF name
Dim filename As String = req.GetAccountNumber()
[Code]....
I have created a page containing the Wizard control. It's a very simple one. User selects some data on the first page, clicks Next and then has a choice of Previous or Finish. When they click Finish the form is submitted but, for some reason, the font size of all my labels increases. There's nothing in the code of the Finish button that would do that.
View 1 RepliesI receive a decimal number with a maximum of 4 digits after the "." and I know this number is in milligram.
I have to find the best matching unit (milligram, gram, kilogram) for the number.
for an example if I receive
edited
116000000.0000 milligram, it's going to return 116.0000 kilogram
66990000.0000 milligram, it's going to return 66.9900 kilogram
49000010.0000 milligram, it's going to return 49000.0100 g
[Code]....
Consider the following :
Dim Length1 As Double = (10* 12) + 5
Dim SqFt1 As Double = 0.0
Dim length2 As Double = Length1 / 12.0
Dim tape As Double = CType(210.0, Double)
'Length2 at this point has a value = 10.41666
SqFt1 = CType(length2 * tape, Double)
[Code]...
I exported xlxs files to sql server using oledb data reader. I'm using visual studio 2005. [code]
View 3 RepliesI want to use numbers with a precision of hundreds of decimal places.
I know of the BigInteger datatype for ints, but System.Numerics falls short beyond the decimal.
How can I achieve anything beyond a simple Decimal/Double precision in vb.net?
how to get 1.83333333333... to 1.83?
Dim temp_1 As String
temp_1 = 5.50 / 3
Label1.Text = String.Format(temp_1, "{0.00}")
I am attempting to read a series of double prcision float values (x,y,z coordinates) from a binary file using the binary reader. Everything works fine except that when I read the number back it is different then the number that was written there (original file is generated by mining application).
written number : 78897.6476586
file contents hex : 40 F3 43 1A 5C CF 43 A4 this converts back to the same number as written using a IEE 754 conversion program. VB returned value : -5.45100266729248E-134 using .readDouble()
I have tried to step thru the file in one byte steps to make sure that I have the proper start position but that did not help any.
I need a function which will Round a number UP to the specified decimal precision, exactly the same as how Excel's RoundUp function works:
Roundup(dblVal, intDecPlaces)
So I need the following:
Roundup(0.896523, 4)
would return
0.8966
However, everything i've tried/found simply rounds to the nearest whole integer, or returns a normal rounded value, hence the above would return
0.8965
I've tried the following:
Math.Round(dblval, intPrecision, midpointrounding.awayfromzero)
' and
Math.Round(dblval, intPrecision, midpointrounding.toeven)
And even custom functions, such as:
Public Function RoundUp(ByVal varValue As Object, _
ByVal iNum As Integer) As Double
'ignore the data types here, I was playing to see 'if changing any of the data types would swing 'the results (knowing full well they wouldnt make 'a difference, thats how fed up with this I am!)
Dim lNum As Long, xVal As Double, xVar As Object
xVar = Fix(varValue)
[CODE]...
I've even looked at converting this to a string, looking at the Xth decimal place, and incrementing it up by 1, then converting it back to a double, while this works (sort of) it seems to be a very roughshod way of doing it, and I'd rather do it mathematically than with lots of data conversion.
I've a scenario where I've to move data from a Oracle Table to a SQL Server table. The column in Oracle is Timestamp(6) 6 being the precision. Now I cannot send the Oracle Data in string format. I pull the data straight from the Oracle Table, so cannot format it on oracle side. What I can do is format the data using VB6.Format to make it suitable for SQL Server DateTime. I'm doing this for Oracle Date to SQL Server Datetime
View 1 RepliesI've a scenario where I've to move data from a Oracle Table to a SQL Server table. The column in Oracle is Timestamp(6) 6 being the precision. Now I cannot send the Oracle Data in string format. I pull the data straight from the Oracle Table, so cannot format it on oracle side. What I can do is format the data using VB6.Format to make it suitable for SQL Server DateTime. I'm doing this for Oracle Date to SQL Server Datetime. Can something similar be done for timestamp and Datetime.
View 1 RepliesI am making the belated transition from VB6 to VB.NET (2008). I would appreciate some guidance on writing arrays to a file. I need to save and load large arrays of 4-byte floats (24 x 90,000 values is not uncommon). I can load or save them using nested for-next loops, but that's quite slow. I'd like to find a single operation that can read or write the binary data.In VB6 I could accomplish this (writing case shown) with Put #1 , , MyArray()I can read and write single variables from binary files without problems in .net. For example, [code]I have looked and looked, and Googled endlessly, but cannot find out how to accomplish a single-line numeric, floating-point array read or write in VB.NET.
View 3 RepliesPrivate Function SingleToIEEE754Hex(ByVal pValue As Single) As String
[Code]...
We are working on an ASP.Net/VB.Net application using Enterprise Library for our data access (DAAB).
We are trying to store DateTime values in an Oracle Date field. However, the precision is being lost. Currently only the year, month, and date are being stored. We need better precision than this.
Oracle Dates are supposed to "includes not just the month, day, and year, but also
the hour, minute, and second. "
the goal i want to accomplish is when the user presses a button, "moneyamount" increases by a random number generated. the problem i am having is that after the action is finished the script does not seem to save the new value and always starts at zero. here is the script:
Private Sub button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dojob1button.Click
Dim moneyamount As Integer = moneyamount + Int(Rnd() * 10)
moneylabel.Text = "$" & moneyamount
End Sub
This is a mathematics "testing" program, after every correct answer it increases the variable "userScore" by 1. This works perfectly along with the rest of the program, the only problem is that even when the answer the user inputs is WRONG and a message telling them they have got it wrong appears it STILL increments the "userScore" variable by 1..
Public Class frmMultiplication
'declare correctanswer as a variable which can be seen by the whole program
Dim Correctanswer As Integer[code].....
I am trying to create a simple Word doc that when the user presses the button it takes the information in the boxes and tosses it into a template style paragraph. But my issue is that I have two combo list boxes as seen in the picture. I want to have two values in the drop down list as seen in the labels next to them but for the life of me I can't figure out how to do this in Word 2007. In Visual Studio this is much easier but I am work and need to snap this out for the folks at work. Is there an option that I can choose in the properties where I type in the values for each drop down or do I have to add them in at run time?
View 1 RepliesI'm adding labels at runtime to my form with a tag. Let's say I have 3 labels with the tags, "1", "2" and "3". I'm adding the tags by counting the labels + 1. When I remove a label with tag "2" from the form there are only 2 left. When I add a new label it will add a new tag "3", but that one already exist. So my "solution" isn't a very good one Although tag "2" is free, I want to give it "4". Any thoughts on how to code this properly?
View 2 Repliesis there anyway to sleep a thread for a "tick". i.e. the tick in StopWatch.ElapsedTick. right now the best i could achieve is this thread.sleep(1). i need it faster
View 13 Replies