Converting Strings For Mathematical Calculations?
Jul 15, 2010
I'm new to .NET and converting and proper way to convert strings to other values. Specifically, here is a situation I'm facing:
I'm returning two values from a datasource as strings. One values is a representation of a span of time, and another is a count of how many attempts to access a system took place within the span of time.
Given these parameters (for example):
Span of time: 00:01:00
Attempts: 13
I'd like to calculate a third value that shows how many seconds each attempt to connect took place during that span of time. This involves converting the time span to seconds and then dividing by attempts. Where I am getting lost is with the conversion of types. I know the span of time needs to be converted to a date, reduced to seconds, then converted to a number to be divided by the attempts field, also converted to a number.
I've been playing around with code segments like this all morning to no avail:
VBNET Code:
Dim thisTime As String = "00:01:00"
Dim thisAttempts As String = "13"
Label1.Text = thisTime
Label2.Text = thisAttempts
Label3.Text = Math.Round(Integer.Parse(Convert.ToDateTime(Label1.Text)) / Integer.Parse(Label2.Text), 2)
View 2 Replies
Similar Messages:
Feb 23, 2010
when to use what type of conversion? For example when writing a class that would update a record I never know when to use
1. Convert.To...
2. int.Parce(...)
3. (int)....
What is the difference?, when would you use which?
SQL = " UPDATE Search WITH (ROWLOCK) SET "
+ " Keyword = " + (string) OR (Convert.ToString) (Keyword)
+ ",PageRank = " + [code]....
View 3 Replies
Jan 13, 2011
I am working on a query to pull the revenue for the last 7 days, as individual days, to be used in a bar graph. My query does what I want it to:
[Code]....
My question is: How do I change the Date1, Date2, Date3, etc to display the actual date it is pulling from? So instead of Date1, it will say "Jan. 3 2011" and so on...
View 2 Replies
Jan 10, 2011
IS it possible to use mathematical symbols in asp.net application.
I am developing a online assessment web application. In that I need to use mathematical sysmbols as question and the user also should be able to use that symbols.
Is it possible? Is any other third party editor is required?
Can I store that symbols into MS SQL database?
View 2 Replies
Aug 25, 2010
I am looking into the possibility of shortening / encrypting a url which will be from 150 to 250 characters in length to maximum 12 characters using an algorithm. Initially I am doubting it's possible but I wanted to leverage the great minds of StackOverflow :)
the algorithm should be one that can be written in classic asp, sql, c#, vb, or foxpro or other language.
Is that even possible without a database centric approach?
I was reading here that AES in CFB mode, will do a stream cipher and the output length will be the same as the input length. Is there any way to shorten it even more?
View 4 Replies
Dec 13, 2010
Any open source javascript mathematical formula editor to recommend? I want to add mathematical formula editor to my web site, so that when people submit message using text box, they can insert related mathematical formula.
BTW: I am using VSTS 2010 + C# + .Net 4.0 + ASP.Net + IIS 7.0, any such controls provided by MSFT?
View 3 Replies
May 27, 2010
I want to create an editor for mathematical and Sceintific Equations.
My clients requirement is that he wants to set the Exam for students and need an editor for all mathematical and Scientific equations.
View 2 Replies
Jan 14, 2011
Is it possible to perform mathematical operations within a .aspx View.? for example..lets say i have a total number of pencils of say 100. and i have 12 students on a data table with his or her name, and the number of pencils she has
Student Name: Pencil #
John 10
Sarah 12
Linus 19
But while rendering the view i want to calculate the Percentage of pencils one student possesses out of the total. (John would have 10% of the total 100 pencils)
How would i just perform this basic math operation, and encode the result into the view. I know i need to store the 100, and divide by each count of pencils for each student within the foreach loop. but i keep getting 0. This seems very elementary i know.. Help would be very appreciated. Google seems to have nothing for me.
View 3 Replies
Sep 15, 2012
how you have implemented mathematics type captcha in comments sections in URL...I like to implement this type of captcha security, its more clean and user friendly.
View 1 Replies
Mar 17, 2010
Is there a way to perform a mathematical equation on a field which has been EVAL'd in a gridview?
[Code]....
View 3 Replies
Jun 3, 2010
We have one new project to implement. Let me explain briefly about this project. This project is related showing chart to end user on the basis of different mathematical calculated formulas.
End user has authority to change these formulas on the fly and on the basis of that changed formula we need to show the chart. So this is all central idea about the project. These charts which I mentioned above are very complicated and user friendly
So can any buddy tell me which is best suitable architecture for this and how can fit her to my scenario .I knows, three tier architecture and some other are there but I want know which is the best architectures that developed above idea in right way
View 3 Replies
Apr 8, 2010
I am having 2 textbox fields named date of birth and age. I have coded in C# in the textchanged event of Date of Birth text field to calculation age and display it in the age text field. For this i have given autopostback true to Date of birth field. I want to calculate age without autopostback,
View 7 Replies
Jan 12, 2011
I have two textBox, one button and one gridview. In one texbox, I enter a value, click the button to add this entry to the gridview and the footer is computing the sum as i add more entries to the gridview.
I also have a textbox outside the gridview that will hold an amount, now I want to perform an operation like...(txtOutsideGridview - gridviewEntry1 - gridviewEntry2), and display the result of this operation inside the footer of the gridview, instead of the sum. How do I go about doing this?
So far all I have been able to do is sum up the total of entries within the Gridview, but that is not my desired operation...here is what my current code looks like
[Code]....
View 2 Replies
Mar 22, 2010
I'm working on an ASP.NET web app where I'm using a Wizard to take the client through a large series of steps.One of the steps includes calculating a bunch of numbers on the fly... the numbers calculate properly but when I click "next" and then go back again... some of the numbers are not retained.
function CalculateFields() {
txtSellingPrice = document.getElementById('<%=txtSellingPrice.ClientID %>');
//I get all of the elements like this...
//...
var regexp = /[$,]/g;xt" and then "previous"
[code]...
View 1 Replies
Jan 24, 2011
I want to enforce some calculation to my project, my requirement as follows. I have txtQtyReq,txtQtyyRec,txtQtyShor(All are 3 textboxes) on load all the 3 textbox/columns should show as "0".(QtyShort=QtyReq-QtyRec)I need to calculate/implement this in txtQtyShort column. when i give a value in txtQtyReq as "50" ,it should calculate QtyShort and display as 50.
txtQtyReq txtQtyRec
txtQtyShort(=txtQtyReq-txtQtyRec)
0 0 0
50 0 50
50 20 30
txtQtyReq=Quantity Required
txtQtyRec=Quantity Received
txtQtyShort=Qunatity short
View 13 Replies
May 23, 2010
I am doing small banking project in that i want to create calculations on interest. in which i have to create that in stored procedures or userdefined funcations
View 1 Replies
May 13, 2010
I'm building a site where users can purchase 'credits' and buy items on the website with them. I'm wondering, what is the best way of storing the user's overall Credits value? Is it best to do a SUM() of all Credits they have purchased before from the 'Credits.Orders' table, or for performance purposes when they add credits to their account, should it increase a 'Credits' field value in a 'Users' table? For consistency purposes I would like to go with the first option, but the second option sounds better in terms of not running loads of pointless calculations every time I need to know their credit value.
View 1 Replies
Nov 29, 2010
image of my listview: I want to total every row from my listview tallies total infected people and percentage
CityID | City | Population | Male | Female | Total | Percentage |
Population, male, and female columns are user inputs total column is male+female textbox value per row percentage= (total/population)*100 also per row to calculate total and percentage on every textchange
<asp:ListView ID="ListView1" runat="server">
<LayoutTemplate>
<table style="border: solid 2px #336699;" cellspacing="0" cellpadding="3" rules="all">
<tr style="background-color: #336699; color: White;">
<th>City</th>
<th>Population</th>
<th>Male</th>
<th>Female</th>
<th>Total</th>
<th>%</th>
</tr>
<tbody>
<asp:PlaceHolder ID="itemPlaceHolder" runat="server" />
</tbody>
</table>
</LayoutTemplate>
<ItemTemplate>
<tr>
<td> <asp:Label ID="lblCtyID" runat="server" Text='<%# Bind("CityID") %>' /> </td>
<td> <asp:Label ID="lblCty" runat="server" Text='<%# Bind("CityName") %>'/> </td>
<td><asp:TextBox ID="txtPopu" runat="server"/></td>............................
View 2 Replies
Mar 20, 2010
i am building a small library system and i am at the part where i need to calculate wether the book is overdue and issue a fine atm i have a filter search which finds the Loan through the book copy number and ISBN number this displays the userid and the start date of which the loan was issued in a gridview, i then added a colum to the loan table to allow the "librarian" to insert the return date of the book with the update feature on the gridview, and then once then update is made make a calucation with those 2 dates
and either issue a output of "thanks for returning the book" or "you book is overdue by. and your charge is ..." depending on the results. the oveduerate is if its overdue by 14days then add £0.20 for everyday over sorry for the long description and thought id say iam just started to learn asp.net. i am building this in Visual Studio and C#
View 16 Replies
Jan 28, 2011
I want to enforce some calculation to my project, my requirement as follows. I have txtQtyReq,txtQtyyRec,txtQtyShor(All are 3 textboxes) on load all the 3 textbox/columns should show as "0".(QtyShort=QtyReq-QtyRec)I need to calculate/implement this in txtQtyShort column.when i give a value in txtQtyReq as "50" ,it should calculate QtyShort and display as 50.
txtQtyReq txtQtyRec txtQtyShort(=txtQtyReq-txtQtyRec)
0 0 0
50 0 50
50 20 30
txtQtyReq=Quantity Required
txtQtyRec=Quantity Received
txtQtyShort=Qunatity short
I got an excellant solution as follows.
[Code]....
View 8 Replies
Apr 21, 2010
I'm trying to render some text into a specific part of an image in a Web Forms app. The text will be user entered, so I want to vary the font size to make sure it fits within the bounding box.
I have code that was doing this fine on my proof-of-concept implementation, but I'm now trying it against the assets from the designer, which are larger, and I'm getting some odd results.
I'm running the size calculation as follows:
StringFormat fmt = new StringFormat();
fmt.Alignment = StringAlignment.Center;
fmt.LineAlignment = StringAlignment.Near;
fmt.FormatFlags = StringFormatFlags.NoClip;
fmt.Trimming = StringTrimming.None;
[Code]....
Now I have two problems.
Firstly, the text sometimes insists on wrapping by inserting a line-break within a word, when it should just fail to fit and cause the while loop to decrement again. I can't see why it is that Graphics.MeasureCharacterRanges thinks that this fits within the box when it shouldn't be word-wrapping within a word. This behaviour is exhibited irrespective of the character set used (I get it in Latin alphabet words, as well as other parts of the Unicode range, like Cyrillic, Greek, Georgian and Armenian). Is there some setting I should be using to force Graphics.MeasureCharacterRanges only to be word-wrapping at whitespace characters (or hyphens)? This first problem is the same as post 2499067.
Secondly, in scaling up to the new image and font size, Graphics.MeasureCharacterRanges is giving me heights that are wildly off. The RectangleF I am drawing within corresponds to a visually apparent area of the image, so I can easily see when the text is being decremented more than is necessary. Yet when I pass it some text, the GetBounds call is giving me a height that is almost double what it's actually taking.
Using trial and error to set the __minimumSize to force an exit from the while loop, I can see that 24pt text fits within the bounding box, yet Graphics.MeasureCharacterRanges is reporting that the height of that text, once rendered to the image, is 122px (when the bounding box is 64px tall and it fits within that box). Indeed, without forcing the matter, the while loop iterates to 18pt, at which point Graphics.MeasureCharacterRanges returns a value that fits.
The trace log excerpt is as follows:
Decrementing font size to 24, as size is 193×122 and limit is 212×64
Decrementing font size to 23, as size is 191×117 and limit is 212×64
Decrementing font size to 22, as size is 200×75 and limit is 212×64
Decrementing font size to 21, as size is 192×71 and limit is 212×64
Decrementing font size to 20, as size is 198×68 and limit is 212×64
Decrementing font size to 19, as size is 185×65 and limit is 212×64
Writing VENNEGOOR of HESSELINK in DIN-Black at 18pt, size is 178×61 and limit is 212×64
So why is Graphics.MeasureCharacterRanges giving me a wrong result? I could understand it being, say, the line height of the font if the loop stopped around 21pt (which would visually fit, if I screenshot the results and measure it in Paint.Net), but it's going far further than it should be doing because, frankly, it's returning the wrong damn results.
View 2 Replies
Dec 23, 2010
I'm working in a ASP.NET project wich is suposed to do several financial calculantions involving potentiations, nth roots, etc. For this first operations, I can easily solve the problem using Math. But, for calculating work days - like Excel, or monthly loan payment, interest rates, etc. - like HP 12C, there is a library that implements these functions?
View 2 Replies
Jun 3, 2010
I have a gridview with the following columns: months, number of injury, expenses. my month column is a string, my number of injury column is a number and my expenses column is a number. I need to first obtain the month column as an integer and then obtain the number of injury column in my gridview. Once these columns are obtained, I want to be able to get the total number of injuries. How do I solve the problem. First obtain the month column and change it to an interger or gridview
Next obtain the injury column and then add each row in the injury column to get the total number of injuries.
View 9 Replies
Jun 10, 2010
In a details or form view I have a number of entries from a database
For example:
Pass-Attempts, Passes-Completed, AvgYds, TdPercentage
If I want to perform a simple calculation on these values, and then display them in the same details/form view
Such as:
QBRating =((Passes-Completed/Pass-Attempts)*100)+(AvgYds*5)+(TDPercentage*4)
With the ideal result being:
Pass-Attempts, Passes-Completed, AvgYds, TdPercentage, QBRating on the same Details/Form view.
So basically I need to programmatically get at those values, perform calculations on them and them display them back in the same control.
View 3 Replies
Jan 17, 2011
I have a FormView Bound to an SQL data source. In the DATA there are 2 columns that i would like to multiply together and display there rate
<asp:TextBox ID="txtPeople" runat="server" Text='<%# Bind("People") %>'></asp:TextBox><asp:TextBox ID="txtRate" runat="server" Text='<%# Bind("Rate") %>'></asp:TextBox><asp:TextBox ID="txtTotal" runat="server" Text='<%# Bind("Rate * People") %>'></asp:TextBox>
This is just an example above but i believe it shows what i am trying to do, there is no calculated column in the database so i can not bind to that directly, and i can not just add the column to the data as its not in my permissions. So how do "Bind" the value of two columns multiplied together to a third text box?
View 3 Replies