i have three cells in a datagridview third cell gives the result of multiplying first and second cell.When i reload or populate this data from datatable into that datagridview value comes like 40.00. with two decimals. For example
58.00 -------->i need only 58
58.78--------->i need exact 58.78
The only problem is to remove the decimals if they are 0.
Dim y as integer
dim x as double = 125 / 60
y = Convert.ToInt32(x) 'removes decimals
That method works, it removes all the numbers after the decimal.
But, how to check if the double contains a decimal and if it has it, remove all the numbers after it?
I have tested all the possible solutions i can think of, but I always run into a lot of errors
I need to get my label outputting the slope to only have 4 decimal digits. I have it set as single now
View 4 Repliesi have data coming from sql server with two columns like total items, total packed items. Now in datagridview i want to show another column to calculate %age.Total Packed Items / Total Items Is it possible to add calculated column in datagridview?
View 4 RepliesThis comparison shows the different values of the known good checksum calculation (c#) as used by my client and what I 'hoped' was the vb.net equivalent. How can I get 405 rather than 513 as I currently do?
For i = 0 To length - 2 Step 1
cksum += sendFrameData(i + 5)
Next i
[Code]....
I am attempting to develop a Gradebook that one can use to modify grades and have an average calculated at the end.When you first open the form, you see the database fields in the DataGrid (socSecNumber, firstExam, secondExam, finalExam)I have a button to save the changes made here. The exam grades are null in the database.This seems to work fine, however I have a problem with the calculated column I want to add. I want it to display the socSecNumber and the average for that student. Instead, I get all four fields in addition to the semAverage field. Also, all the grades come up 250 if I fill all the fields in with 100.[code]
View 2 Repliesi have a problem with my program i want to work with 2 color's red and green i want get the red color if the calculated - and green if it is +
[Code]...
I have a DataGridView that call a stored procedure. One of the fields is a calculated field, ie Quantity * Price.When I run the stored proc on the server, the calculated field returns a result that shows 2 decimal places to the right of the decimal point. When I run the stored proc in the VB application to fill the DGV, the result in the calculated field shows up to 8 places to the right of the decimal place. Is there a way that it will show only 2 places in the application?
View 3 RepliesHow are coordinates calculated on a form?
Consider the following code:
[Code].....
I am attempting to copy the value of the TimeStamp in cell A6 which has the NOW() formula into cell A5 Based on a change in Cell A4. The catch is I don't want it to update every time the sheet is recalculated due to updating links in other cells on the sheet. ONLY when Cell A4 Changes. What do I do?
View 2 RepliesI have a textbox that requires the user to input the value of the Value-Added Tax of that certain area. I tried testing 12.5%. The string is converted to decimal then divided by 100 so 12.5/100 = .125. But when the program writes the value to a file, 0 is writen. not .125
View 23 RepliesIf i wanted to know if a whole number is a multiple of 10 or not I know i can do for e.g
If VarWholeNumber MOD 10 = 1 Then
......
Endif
But if i have a whole number with format "0.00" how can i only check if the last 2 digits after the decimal is a mod of 10 regardless of what the whole number sides value is.
So something like
If VarWholeNumber's ".00" MOD 10 = 1 Then
.......
Endif
How could I could this?
i need it to look at the coloum in a datagrid and make the back colour red if over 1.6(in sql this field is saved as Varchar(10))but at the min, i have a value of 1.5 and it is making the back colour red
Dim cell As DataGridViewCell
Dim CellVar As Integer
For Each row As DataGridViewRow In Me.OEEGrid.Rows
cell = row.Cells("CD")
[code].....
I'm just curious that how a month is calculated in the rest of the world because Differences in Months between two dates are calculated differently. In our Insurance Company, we calculate a month as below:
[Code]...
I have a DataGrid as a child of a Customer Form based on a Query like this
[code]...
how to change this Linq to Entities (VB.Net) query to Group by L2_ID column and aggregate the calculated column diff as Sum for the group.
[Code]...
I have a gridview that displays a calculated field, based on a db source field it populates with.
can i sort by it? i can't seem to figure out how to do it?
example:
my templatefield looks like this:
<asp:TemplateField HeaderText="Category" SortExpression="category" >
<ItemTemplate>
<asp:Label runat="server" Text='<%# BuildCategory(DataBinder.Eval(Container, "DataItem.category")) %>'
ID="lblPrice"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
where category is party of the datasource, but what gets displayed is a calculated value - which is different from the category.what can i put in the "SOrtExpression" to make it sort by the new value - taht gets displayed?
I am attempting to teach myself visual basic and I cannot figure out how to send a calculated value (on a button click) into a one-dimension array and then recall the last five values in a message box when the user exits.
Here's what I have:
Public Class frmInvoiceTotal
Dim totals(4) As Decimal
Private Sub btnCalculate_Click(ByVal sender As System.Object,
[Code]....
My program is databound to an access 2007 database. I have a datagridview showing rows as part of my screen and the other part of my screen is texboxes bound to a different table.What I currently have:
1. Date in textbox from one table
2. Age in Datagridview column from another table
I need help with having a calculated date column in the datagridview that will be the textbox date + age (in days) in the datagrid column. I would also need this column to store in my database like any other field also. So if I typed in 2/17/11 into the textbox, and I typed in 2 in the age field, the calculated field would display and store 2/19/2011 in my datagrid and database. My dataset designer won't let me add a date to a string so I'm completely lost. A query calculates it easy in access but when I load the access query in my dataset it doesn't calculate anymore.
I am using two forms and the results from form 1 i want to show on form two.The results are in dB(decibel). I get a long result lile 142.1233344444 dB. I want this result be like this 142.12 dB. I use value _passedText to get value from form 1 and display it on form 2 textbox results.text
passedText = Value
Results.Text = Value
What should i do to round off it in vb.net 2008.
Is this the proper way to bring up an error if the user inputs more than 2 decimals. 'Not decCost = [0-9]*.[0-9]{0,2}
[Code]...
I have invoice form bound to a bindingsource and bindingnavigator. In the form I have unit price, quantity and total textboxes. The total textbox text property is set to total.text = quantity.text * unitprice.text in the textChanged event of both quantity and unitprice text boxes. The result is displayed in the total textbox. But when i hit save button on the bindingnavigator it is set to null and not saved to database. [code]When I used msgbox to see the value of total textbox before bindingsource.endEdit() it is the correct value. but after the code bindingsource.endEdit() it is null. I checked the databinding property and it is correct. What is the problem.
View 1 RepliesI am working with a future value application and I am trying to display the calculated future values in a listbox. For instance, I input the monthly investment, the yearly interest rate and the number of years into textboxes and I want the application to list out the future value for each year until the number of years in which I entered is reached. I cannot figure out how to get the code to display the value after each year. I am trying to use the "mod" operator to display the value each time the 12th month comes around.[code]...
View 7 RepliesI have a RDLC report with a list that contains a table. I require a calculated column whose value depends on values from previous rows. Outside of a report I accomplish the same thing using code in a DataGridView's DataBindingComplete method.
From within a report how do I refer to specific cell values from previous rows? embedded code, but I have not had luck (#Error).
ive been struggling on this portion of my code for almost 3 days with no luck. i have a database containing a list of transactions (in this case, the product name, quantity and date of sale). I want to plot a graph for each product showing the amount sold each month for the past 12 months. The functions to calculate these values are working fine. but my problem is this:
each tab page is named after the product name:
TabControl_SaleOfProducts.TabPages.Add(
"TabPage_"
& ProductName, Item)
and then to this tab page i want to add the graph. but i cannot reference the newly created tab page?
I'm trying to check for the number of decimals in a textbox, but I'm not very successful so far:[code]How can I correct my code to make it work? Or any other/better solutions?
View 2 RepliesI've used .NET for a long time now but I have come across something I haven't had to do before and I'm struggling to work it out. What I need to do is work with binary numbers and convert them to decimals and vice versa but not necessarily using even numbers e.g. I would like to represent a number between 0 and 2047 which can be represented with 11 binary digits. Plus I want to represent a second number between 0 and 500000 which can be represented with 19 binary digits, and a third number, fourth etc. Then I want to string the whole binary results together and split it in to sections of lets say 5 bits each and convert those back to decimal.
[Code]...
how do you detect how many decimals a decimal number has
View 10 RepliesThe 4 decimal point to 2 decimal point in a listview.... here is the code for displaying the data from the database to listview.[code]...
View 1 RepliesHere's a silly question. I cannot believe I've spent so much time trying to figure it out. I have a textbox where I enter numbers, such as 12, 12.3, etc. I would like this data to display as 12.0000, 12.3000, etc. My line of code looks like this:
[Code]...