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
Do we have any free 3rd party library that we can use in asp.net for download Excel sheets?
View 5 RepliesI want to read and write excel file . it can do with oledb , there is a limitation maximunm characters < 255 solution is mono data type , now create table become second sheet (when open excel it is shown as hidden.)
View 2 RepliesIs it possible to access an object that is used by ObjectDataSource to retrieve records? For example,
<asp:ObjectDataSource ID="MyDS" runat="server"
SelectMethod="getUsers"
TypeName="DataSources.UserDS"
SelectCountMethod = "getUserNum"/>... </asp:ObjectDataSource>
UserDS class has getUsers that returns DataTable and getUserNum that returns int, this part works as it's supposed. But I wonder if can access the instance of UserDS somehow (not underlying DataTable)?
I'm trying to use Dot Liquid which is one of the coolest templating engines for c#.
Dot Liquid uses a way in order to make using templates safe. Here is the explanation page.
Here is the Explanation from it's wiki:
[code]...
So when I pass DataRow to liquid, liquid wont let me show it's content and tells me that:
'System.Data.DataRow' is invalid because it is neither a built-in type nor implements ILiquidizable
Is there any solutions to pass DataRow object that implements ILiquidizable too?
I am looking for a free implementation for Comet or Push. Here is an example of chat done by comet:http://www.phpchatsoftware.com/phpbb/I have my own server.Is there any thing like this?P.S. I am using asp.NET, on server and jQuery on client.Is there anything new? or maybe this is the last technological free open source achievement:http://www.codeproject.com/KB/aspnet/CometAsync.aspx ?
View 4 RepliesI have finished coding a project and need to do a class diagram for my documentation is there a way to make a class diagram in Web Developer 2010? I remeber there was a feature that implements a Class Diagram in C# 2005 but not sure in 2008 and web devekoper 2010.
View 4 RepliesI created an application and implemented IHTTPHandler for all incoming request ending with ".aspx" extension.Under "ProcessRequest" module, I am creating an instance of HttpContext (with URL attributes different from my application's URL i.e. if I am working on localhost then speciying Yahoo.com as its URL) and assigning it to "context" which comes as method argument.After redirection, an error is generated. Also, the custom HTTPContext is not passed to the requested page (default.aspx, in my case.)Code is as follows.
[Code]....
i use following code to calculate financial year.when i select a date in calendar extender then financial year dispaly in a textbox.i need it in maskedit extender.how can i do in in Maskedit extender.
[Code]....
[Code]....
I want to apply regression analysis on my financial data.Can anybody have the sample code for this.And which method i should prefer for financial.
View 1 RepliesI need to display many pages of financial statements on ASP.net and I have already had these numbers stored in database. I tried to use Gridview but it is very hard to display the sums etc and we have to write code for every subtotal which takes me forever. I decided not to use Gridview but just wondering what free reporting control to use for my scenario.
What I need to do on the page is to present income statements like this:-
Sales Revenue 2000
Cost of Sales 1000
----------
Gross Profit (calculated field) 1000 (=2000-1000)
Admin Cost 200
----------
Net Profit 800 (Calculated Field = 1000-200)
======
The above is over-simplified version and there are many many sub-totals in my page.
All I have is Microsoft Access datasbase and I don't have full version of VS 2008 so I don't have crystalreport.
Is there way I can have free crystal report or any kind of open source reporting control that work well with ASP.net ?
i want to design a stock financial report system and fortunately i hooked in the database design part. The report is made up of different sector and under the sectors thier are companies. All sectors have some unique entry fields which makes it different from the other. for example banking sector is different from insurance sector because there are entries that differ. My problem is how to create a non-redundant database that features all the sectors and companies. the idea i thought is to make a table for every sector and i found out that with these idea i wil have some relational issues for example in each sector i will have company id as primary so in establsiing relation i will hav constraint.
how to design a non-redundant databse with respect to these subject.
I need financial year in system date.actually i calculate financial year like below in VB code. [Code]....
i just like the same in sql server query.for example suppose my query like"select*from admission where std_code=1 and fnyr in (select finy in system date)"<---i need here.
"How to write a regular expression to validate Financial Year(For E.g: 2000-2001,2001-2002, etc...)
Note: If the Starting Year is 2000 then the ending year should be 2001 .
I am looking at the twitter api page http://apiwiki.twitter.com/ and I noticed that they have already built libraries that are wrappers against the twitter api. So I am thinking this is the best way to go but I am unsure which C# library I should use.
What I am trying to do is make some simple service or cmd line application that will help me automate retweeting.
So I am looking for a library that will allow me to get posts from other twitter accounts and then retweet them from another account.
I am not sure if the library can do this or not. Otherwise I was thinking of getting the RSS feed from the twiter account I want to get the twitters from parse out the new ones and use a library to retweet them on my own account.
I have not used twitter much so I am hopping someone can shed some light on this.
I want to calculate the current financial year in my stored procedure and use it when generating a unique Id for the customer registring in my system.
View 2 RepliesI 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 RepliesI'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)
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]...
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 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 RepliesI'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 Repliesimage 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>............................
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#
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]....
