What's the deal with those 23 unused bits in the Decimal data type? You know, there's the 96-bit integer portion, then 16 unused bits, then 8 bits for the exponent (which can only be 0 through 28, so doesn't even use all 8 bits), then 7 more unused bits, then the sign bit [URL]...
View 1 RepliesI am pulling data from a local MSSQL database using a stored procedure, then send the data to a web service. Every part of the component works well except for a pesky problem will a DBNull being returned from the DataRow field, when I know that the field is not null and has valid data. The database and associated INSERT statements that add to this field are designed to not allow NULL entries. When I debug break the program on or right before the line that throws the error I see that the field has valid data for the current row.If I add a null check to the code (as below) the operation continues as normal:
Dim dataResultsTable = Me.myViewTableAdapter.GetData(int)
For Each myDataRow In dataResultsTable.Rows
If worker.CancellationPending Then
[code]....
Why is the read operation returning DBNull instead of the data in the database?
EDIT: Just to be clear, the operation does return the proper data, but the data is not being saved into the variable.
I am converting decimal to binary by:
Code:
Dim i As Int64 = Convert.ToInt64("2")
TextBox1.Text = Convert.ToString(i, 2)
[code].....
I am a visual basic developer, I have windows 7 64 bits and Visual Studio 64 bits installed.CAN I DESIGN APPLICATIONS WITH THESE SETTINGS THAT CAN BE COMPATIBLE with 32 bits operating system(example in windows Xp 32 bits)?
View 2 RepliesI have created some check boxes and buttons, and changed the names, but it seems like the system.properties saved both names now I would like to rename the button back to the original name but the name is being stored for some reason, and I cant access the original name, how do I clean this up?
View 6 RepliesI have to display all the digits of 2^90. This is within the reach of the Decimal format which can display up to 2^96-1. The Decimal format stops displaying after the 15th digit.The real answer for 2^90 is : 12 379 400 392 853 802 274 899 124 224 (29 digits)
Here is what I do:
Dim a As Decimal = 2^90
TextBox1.Text = a
[code].....
my application has a data table, one of the column set as decimal type to store number, data is read from a text file and store into the data table, then display in a datagridview, I found when that number is only 1 digit, that cell displays nothing (I think no number is being store in that cell), if I type a 1 digit number into that cell is fine. for example,
1.1 [ok]
12 [ok]
0.15 [ok]
4 [not display]
9 [not display]
-23.8 [ok]
so which data type I should use on this column, in order to display all this possible numbers
Planning on migrating from 1.1 to 2.0 framework.After doing the automatic vs 2005 migration, it did highlighted lot of lines: due to unused variables and functions with no return type..Is there a tool which can fix those unused variables plus function with no return types.
View 2 RepliesAny way (outside of writing rounding routines) to restrict the number of places after the decimal in a Decimal data-type variable?
View 3 RepliesI want to convert numbers from 0 to 15 like that
[Code]...
Problem is that when we convert 2 to binary number it gives only 10 in binary, but i want to convert 2 to 4 bit binary number 0010.
I'm trying to figure out how to calculate the lower 7 bits and 7-13 bits of two hex numbers.
Here is some example c code, just need this in vb.net:
serialBytes[2] = 0x64 & 0x7F; // Second byte holds the lower 7 bits of target.
serialBytes[3] = (0x64 >> 7) & 0x7F; // Third data byte holds the bits 7-13 of target
The 0x7F is a constant so the only number that changes based off input is the 0x64.
how can I use SQLConfigDataSource to add DSN to the 32 bits ODBC on Windows 7 64 bits? I know it use C:WindowsSysWow64odbcad32.exe and on registry, HKLMSoftwareWow6432Node but the API do not allow me to configure it?how can I do ?
View 1 RepliesAn application created with Visual Basic in Win7 64 bits will it still work fine in both WinXP 32 bits and Win7 32 bits ?
View 6 RepliesI have a Job Register Table and that table doesn't have any records.
This is my LINQ code:
Dim QRecordCount = (From LC In CntxtJobDetails.JobRegistrations _
Where LC.JobCode <> 0 _
[code].....
Is there another way to easily make a POST request in .NET other than the WebRequest class? I have a very, VERY small piece of data I need to post: password=theword but WebRequest randomly, and I mean randomly, drops the data when posting to my server. I've tested it by using a chunk of code from my server that dumps the request to a console, and I can that the client is sometimes sending and sometimes not sending the POST data.The code that I'm using that uses WebRequest works in another project, when talking to IIS. The server being talked to (a minimal web server in another system) responds properly every time I POST data to it through Firefox. I've got a function in the same project that fires off a GET request, and that works. It just seems like my POST function isn't completing the transaction...something I've noticed in the past when asking WebRequest to handle small strings.[code]
View 2 RepliesI have some html that I want to extract any data that is between the following two bits of HTML:
<DIV class="this-text my-data">
</DIV>
What code would do that?
For each column in data table i want to add parameter with same data type as column data type. But looks it's not that simple.
Dim cmd As New SqlCommand
Dim dType As New System.Data.SqlDbType
For Each cl As DataColumn In DataTable1.Columns
[CODE]...
How can I do this?
What is the cleanest, most readable way to String.Format a decimal with the following criteria
start with a sign symbol (+ or -)
a fixed number of fraction digits
no decimal separator
right aligned
pre-padded with "0"'s
I have a piece of code im working on and is stuck on Select Sum statement which keeps returning a Conversion from type DBNull to type Decimal is invalid. Below is the code and Im working with a Access Database. Everything works good if the Batch Number exists and its when the Batch Number does not exist.
[Code]...
I'm trying to detect if a value is a decimal type and insert it into a DB. If the value is a decimal, I want to continue with the inserting. If the value is not a decimal I want to insert "0" as a value to the DB.
For this I created a function seen below... What is wrong with it?
Function IfNotDeci(ByVal Arvo) As String
If Arvo is Decimal = True Then
Return Arvo
[Code]....
The problem is on the first "If". How to know if the value is a decimal?
(I need this code because my values are read from different excel-files that are not always correct. So if a human didn't write a decimal value to a cell, the program should not respond with an error, but just insert a "0".)
I am attempting to convert a DBNull value to a decimal (0, 0.0, 0.00 etc).
My current code is If row.Item("Name of row") Is DBNull.Value Then NameOfRow = Convert.ToDecimal(0.0) End If When i run my app i pass in the row to convert. Every other datatype works/runs as expected except Decimal. It runs with the abbreviated code below:
For each row..in dataset.rows Object = row.table("Table").Item("Name of row")Next The Object.... line causes an error. The error is DBNull' to type 'Decimal' is not valid.... Ive tried many attempts to overcome this but cant get this to work. Could anyone guide me?
here is a very important matter to be corrected as soon as possible. generally,type double can display an answer correct to more than 20 decimal places. yes,it works fine until here except for exponential system. whenever i try to find a decimal raised to the power of a proper fraction, i get a correct answer but only upto 13 decimal places. that is not fair at all! it is important to get as high precision as possible. consider this example:-
[code...]
i want that number of correct decimal places or approximation,which a windows 7 calculator has. i believe that this is someway easy to get rid of. please support.it is important for programs like calculator,worksheets,databases,etc.
When I click on a header (Price) to sort the rows by that column, I get an error Object must be of type decimal.
I'm thinking that I'm encountering a new row without any values that's why this error is being generated.
I'm not sure how to intercept this error or fix it for that matter....
I want to assign a Value to a Variable of Decimal Type to do a calculation, but when I enter the decimal value (a 28 digits to the right of the decimal point - very long numbers) it gets altered. I give below what I was doing:
Dim MyNumber As Decimal = 0.7777777777777777777777777774
But as soon as I finish typing the number, it becomes 0.77777777777777779 and appears as,
Dim MyNumber As Decimal = 0.77777777777777779
And, when the cursor is kept over the altered number it shows as "Double, Represents a Double - precision floating-point number." How can I get the value I wanted to stay without getting changed? I was able to get this long Decimal value as the result of a calculation and get that appears in a text box in the same program. Is there anything I should change in the "Visual Studio 2008" to get this ?
I need to create a function which have either 1 parameter with a string as data type or 2 parameters with double as data type.Something like the substring method.
View 2 RepliesPlease excuse the newbie question as I started learning VB last week . I wrote the following test code below to add two values entered in two textboxes and display it in another textbox. However I keep getting the exception. "Conversion from string "" to type 'Decimal' is not valid" with the code below and I cannot figure out why . I thought converting using 'CDec' resolves this issue ?
View 3 RepliesI have a variable containing a double type eg, 56.3433253. I want to convert it to a long type and maintain the decimal places.
View 3 RepliesI am trying to insert a variable in Decimal type into an Access table. When I use "decimal" field with 0 digits after the decimal separator (,) my program works properly. However, when i use the field with 2 digits after the separator I get a "Data type mismatch in criteria expression." exception. This happens also when I try to update the table. The debugger shows me that my variables contain the right values but the update or insert command gives the error.
View 2 RepliesIm trying to set one variable equal to another but it says "No default member found for type 'Decimal'" what does that mean?Both the varuables are deciamls, one is a regular decimal that I declare in the sub and another is an array that I declare in the class. The line is:
tempx = xo(i)
this is in a for loop with i as the variable.
Is there such a thing as a type similar to a point, but contains a pair of decimals, or a pair of doubles, rather than integers? I searched the forums and google with no luck. I can't believe this has never come up before, I must have been using the wrong search terms.
View 4 Replies