Forms Data Controls :: Decimal Place Missing After Calculation
May 11, 2010
In a formview I need to present a new value calucalted by dividing one field value by another. I need to present the result to one decimal place. The code I am using is the following, however it presents the resulting value rounded up or down to the nearest whole value:
<asp:label id=lblTotal text='<%# Convert.ToInt32(Eval("Value1")) / Convert.ToInt32(Eval("value2")) %>' runat="server"></asp:label>
I did try and insert refernces to {0:N1} but this just threw asp.net errors. Any advise on how I can guarantee that the value calculated is presented to one decimal place?
View 4 Replies
Similar Messages:
Jan 16, 2011
I am displaying a money values in a gridview. Is possible to use inline code to set the decimal places to two? Would like to do it inline instead of in the C# code behind if possible. Database table column [Rate] is datatype money.
GridView1. . . . .
<asp:TemplateField HeaderText="Rate" SortExpression="Rate">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# " total monthly " + "$" + Eval("Rate") %>' ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
View 1 Replies
May 7, 2010
I have a claculation code in my project and it gives the result with too many decimal numbers. I wanna make it shorter as two decimal area. As in sql code, I wanna do a round fuction but I do not know how I could do it in c# ro vb? tolower function?
View 7 Replies
Feb 14, 2011
how to convert the string to 3 decimal place?i want 0.033 for below:
[Code]....
[Code]....
View 2 Replies
Sep 7, 2010
Just to be forward, my .net and c# expierence is very limited, that one could say I'm a complete noob :) However I do have some grasp on OOP as I usually work in PHP (FWIW). My problem seems to be with this line:
Session["total"] = dt.Compute("SUM(price)", "").ToString();
which will output a total of say "9.2" where as the price is "9.20" from a few record lines as such:
dt.Rows.Add(strRecord, 9.20, dropDownListDistrict_stepTitle.Text);
thus 9.20 + 9.20 = "18.40", but the page displays "18.4".
The label that displays the total sum is:
<asp:Label ID="labelTotal3" runat="server" Text="0" />
From what I've gathered, I'm suffering from some kind of type casting problem? Hopefully I haven't missed anything, its a bit difficult to show all the code but hopefully someone can point me in the right direction? Question is; how can I get an extra decimal place to show up on my sum (or why is it dropping the last decimal place?).
View 6 Replies
Mar 4, 2010
i have a double, the decimal place isn't fix (8-?) i want to fix the decimal place to six (for example: 1,234567). this is my double:
CStr(score)
View 3 Replies
Aug 22, 2012
i hav one data table in which some decimal values are up 6 decimal places.. im trying to bind that Data table to DataGridView while binding i want to round decimal values up to two decimal palces here is my code
dt.Columns.Add("Orderid", typeof(string));
dt.Columns.Add("tagnumber", typeof(string));
dt.Columns.Add("Minimum Value", typeof(string));
dt.Columns.Add("Maximum Value", typeof(string));
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
[code]...
hows hould i round up while binding..?
View 1 Replies
May 7, 2015
I was read your post: "Export GridView to Excel in ASP.Net with Formatting using C#" and is very useful. That code works perfect. But I need create a new format for a specific column in my sheet before to export it. For example:My DataTable have a column with decimal numbers and I'm trying reduce the tenths for each number.I want this: 2,874444 ----> 2,87 for a specific range. In this case I need it for all numbers in the column 13 or well said for the Column called N in Excel. Only reduce two tenths.
I used:
xlWorkSheet.Range["N"+h,"N"+h].NumberFormat = "0.00";
And no works (h is for rows, N is the column. Into a foreach).
View 1 Replies
Oct 9, 2010
i have a strange error creaping into my web app but am unsure as to how to fix it. When i run this code on my debug workstation it works fine but when i transfer it to my server things seam to go wrong.
dev station (windows 7) + VS2010
regional and language settings all set to uk
server (windows 2008r2)
regional and language settings all set to uk
What seams to be happening is that when converting a string to a double it works correctly on the dev environment but moves the decimal place to the end on the server.
example code(vb)
dim lat as string = "52.983829"
dim long as string = "-0.036500"
dim latint as double = lat
dim longint as double = long
now on the dev server the value of latint is 52.983829 as you might expect but on when published to the server it becomes 52983829.0 the same with longint on the dev staion it is -0.036500 but on the server it becomes -36500.0 i get equally confusing problems if i try to change it to an integer instead.
View 2 Replies
Dec 1, 2010
I'm not sure how to do this, but I did read a lot of post and searched for it.
Protected Function GetTotal(ByVal DonTotalQty As Decimal, ByVal DonValue As Decimal)
View 5 Replies
Jan 16, 2010
I have two coloumns in a table to store Registered and Closed dates.
I want to calculate the period and to show in labels templated in detailsView.
Period should be like this:
72 Hrs and 58 minutes
View 9 Replies
Oct 10, 2010
Why am I getting this error? I'm trying to do a calculation on my GridView2 and I'm using clientside javascript. I need to add the onkeyup attribute. How do I do this?
Code Behind:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
CType(GridView2.FindControl("TextBox13"), TextBox).Attributes.Add("onkeyup", "calculateSubTotal")
End Sub
View 5 Replies
Mar 11, 2010
I am using a grid form to diplay data... the insert form is completely a separate form. In the insert form a text box called "FormPercentageTextBox" is getting a calculated result using javavascript based on some field ( field1,field2) values (val1, val2).
the problem i have is: when i edit the form and i want to update any value..i want the new calculation result showing on the edited "FormPercentageTextBox" field. I need to have this calculation reflected/
View 2 Replies
Apr 6, 2010
I'm trying to execute this statement every minute with SQL Agent, I have it set up as a job:
[Code]....
It's trying to update a column which data type is set to decimal. Just so you know what I really need out of it, here is an example:
[Code]....
The answer of which should add on 0.5 to the original value. If I were to use the increase value of 60 which then becomes 60/60 it will work.I'm dividing by 60 because the increase value is per hour so I make it smaller to get per minute value. Why is it doing this?
View 2 Replies
Dec 7, 2010
I have a gridview in which i have itemtemplates and label controls having data from sql server.
I have two fields say quantity and units and in third field i want their product. I m trying in rowdatabound event like this-
[Code]....
Here my third field is netvalue.
It is throwing error-
Input string in wrong format.
How can i achieve this?
View 5 Replies
Jan 19, 2010
Here is my page:
[Code]....
It basically is 4 questions with each answer assigned a value.
What I would like to do is when the button is clicked the selected values are retrieved and calculated to give a total.
That total is then compared against some common totals and the next value is shown.
So is the total is 8= Very Good, 6= Very Bad, 4= Terrible etc.
The two labels Result and Truth would sho the numerical result and the truth according to the scale.
I am at a loss on how to retrieve the list button clicked value, how to add them up and referance that to the Truth result.
its complicated (to me its "bang head against wall" difficult.
View 17 Replies
Oct 9, 2012
I have kept four column in gridview with dynamically added row...
E.g.
work type rate noofworker amt
Groundwork 10 100 1000
Earthwork 20 100 2000
Total 3000
OnChange event to fire the calculation...
View 1 Replies
Feb 27, 2010
my query is like this " select product_id, product_price, purchase_amout from purcases"
and on my formview i tried to add a "total purchase"
i tried using <asp:Label ID="total_purchase" runat="server" Text='<%# string.format(cint(eval("product_price")*eval("purchase_amout")),"{ Rp 0:###,###,###,###,###}")%>'>
the total amount show the correct calculation result, but the string format dont work.... so it display 20000 instead of Rp 20,000
btw. "Rp" is the currency symbol in my country... i dont use {0:c} coz the server user US currency
View 4 Replies
Mar 24, 2010
I currently have 3 tables and return an average value for the OverallRating Column on each to get a CombinedOverall, but what if one of the tables does not have data for a particular customer? if I divide by 3 the answer will not be the same, and I could get an answer that is over the max I want (5.0)
[Code]....
It will be possible that the Customer will not have any data in one of the tables.
How do I get around this?
View 10 Replies
Apr 27, 2016
I have 3 dropdownlist for date, month, year. When I select DOB from dropdownlist, the age should be calculated automatically and display in textbox. What can i do?
View 1 Replies
Oct 5, 2012
I have a web page in asp.net+vb code+sql database. in an table named course_intake i want to count i tried some and it works correct but i am not able to add more clouse to it
1. if date1 (field) not equal to date2 (field) then att pd as 1 else 2
2. (OY is a field) if OY Ends is lesser than Jun then Deg Dt as 1 Jul+ OY end year (example if OY is 5 Jun 2012 then deg dt will be 1 Jul 12 else 1 Dec 12)
3. Count from COURSE_INTAKE where OY LIKE 'YO-' WHERE ENTRY_COURSE= ENTRY_COURSE
4. Count from COURSE_INTAKE where OY LIKE 'TAKEN YO-' WHERE ENTRY_COURSE= ENTRY_COURSE
5. Count from COURSE_INTAKE where OY LIKE 'DONE' WHERE ENTRY_COURSE= ENTRY_COURSE
My code is as under
select ENTRY_course,COUNT(*) as Str,convert (varchar, DTsen,6) as [DTSEN],convert (varchar, DTCOM,6) as [DTCOM],
dbo.getBTechBECount(ENTRY_course) as 'BTECH',batch,dbo.getMedCount(ENTRY_course) as 'MED',convert (varchar,
DTCOM+396,6) as [AVL for OY], str-btech AS [STR AVL]
FROM COURSE_INTAKE group by ENTRY_course,DTCOM,dtsen,batch, str-btech ORDER BY dtcom
View 1 Replies
Mar 5, 2010
I did the following:
(1) File / New / Web Site
(2) Right-clicked on new website name
(3) Selected "Add New Item..."
(4) Selected Web Form
(5) Didn't see any check boxes for selecting either "Place code in separate file", or "Select master page".
The checkboxes are missing. Is this a configuration problem?
View 2 Replies
Feb 11, 2014
I am looking at the following article [URL] .... its converting a gridview to excel. On my gridview I have a running total on the footer, and i do know to to change the code or add code to add this to my excel document...
View 1 Replies
Apr 7, 2010
i have one grid which have 5 columns 1 for subject,2,3,4 for marks which have textbox to insert obtained marks,and last column have one lable to display total of (2+3+4),now i want total value on textbox event,when user enter any value to any column of textbox i need to display total of all three columns in total column.
View 2 Replies
Feb 9, 2011
is it possible to convert a Currency value $100.00 to a decimal value of 100.00?
View 1 Replies
