Web Forms :: Regression Analysis On Financial Data?
Jun 16, 2010I 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 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 dynamically add/remove dimensions and facts in web application and get results from SSAS. The cube in SSAS is defined and ready to use. So far the best idea I found is use MDX queries to get metadata from SSAS cube and display those data in web page. Then user can choose needed dimensions/facts and I need to costruct dynamic MDX query and get results from SSAS. Communication with SSAS is made with AdomdDataReader. Is there better options to solve this task that require less effor? Maybe somehow make use of Reporting Services (SSRS).
View 1 RepliesI want one column Category having values Travelling,Food,Air Fare,Auto Rental in gridview.Now I want date and day as header for next columns and I can insert record datewise in grid. I want it as following image.
View 1 Replieswe are working in a small team. We often had problems like developer1 did some changes in stored procedure or funtion and it affected work of developer2. Such issues are traced out by chance later. Please guide me how such issues can be stopped. Is there a free tool that we can run to test such issues.
View 3 Replies"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 .
As per this MSDN article:
W3C Extended Log File Format (IIS 6.0)
It says cs(Referrer) contains the REFERER information that can be read from the IIS log files.
I am trying to display the log information using an ASP.NET Repeater control:
<asp:Repeater ID="rptlIISLogEntries" runat="server">
[Code]....
I am using code analysis tool of VS 2010..two things that i have noticed was not provided:
Proper casing of variable,method and properties names xml comments for each method,event and other activities
I am aware of a tool which MS has provided which tells you about coss site scripting attack etc.
The tool is [
But are there tools which you have used for ASP .NET applications which do similar to this and which one is widely used in ASP .Net applications ?
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 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.
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 RepliesIn our project we need to restore the analysis service database back up(.abf) files.Now i can connect to analysis service and can create new database.May i know how i can restore the abf file .i saw i can do this by using sql server SMO dll .check the below link
[URl]
how to get the samples are located in <system_drive>:Program FilesMicrosoft SQL Server100Samples folder,if you alrady installed the documentation
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 RepliesThere is a built in function from the Microsoft.VisualBasic assembly. I can use it in VB like this:
Financial.Pmt((dAPR / 100) / 12, iNumberOfPayments, dLoanAmount) * -1
My current project is in C# and I need to use this function. Answers on the web say just add the namespace and assembly and use the same in C#- but this is not true! C# still does not recognize this formula.
So how can I use use Financial.Pmt in C# (or perhaps even porting the source code to it)?
How to display empty GridView to insert new record if no data retreived for some record on the result from data table?Actually i am trying to give a user an option to add recrod from Gridview. On result of some query it is perfectly displaying data and a footer row with the insertion textbox but when there is no data in the gridview it is not displaying. It should display with footer having insert textbox.
View 5 RepliesI have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....
I have a listview control bound to an SqlDataSource. As part of the formatting I want to add a title to the data returned from my database. For instance if the data base returns a phone number I want to add 'Tel.' first. However I do not want to diplay this
title if the datafield is empty. Here is what I have done so far.
<ItemTemplate>
<asp:Label ID="BusinessLabel" runat="server" Text='<%# "Tel. "+Eval("Business") %>' CssClass="TeleStyle" />
Or This:Tel.
<asp:Label ID="BusinessLabel" runat="server" Text='<%# Eval("Business") %>' CssClass="TeleStyle" />
</ItemTemplate>
Business is a phone number. If the data field contains a number I get: Tel. 1234 123456. If the field is empty I get Tel. If Business is null I want nothing dsplayed, how do I do this?
Using a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
<%# Eval("add_1") & ","%>
<%# Eval("Add_2") & ","%>
<%# Eval("Add_3") & ","%>
OUTPUT:-
Rose Cottage, 123 New Road, Margate,
i have 103 column in database 1 column is id, 1 is user ,1 datetime, 100 button on webpage 1 textbox to input value , button1 clicked then value in textbox will insert into database with user:=user.identity.nam datetime=datetime.now colum4 will get value from textbox......button2 for colum2 and buton100 for column100, if i use dataset i need 100 datataset, some other way to solve it ??
View 2 RepliesI would like to add a column in my datagridview that takes the value from the database and asigns it to the text of a linkbutton or make it a hyperlink. i know how to handle getting the value from the row but dont
know how to make a value a link, or set the text to a link button
in one on my page i am using to add the data from popup window to grid view without using the backend means databasethis is my popup window code
[Code]....
[Code]....
I would like to dropdown box to show only starting from second row of the table. How to use data reader to do it?
View 9 Replies.I have a search page where I would search for an item and it would dispaly the results in a gridview...
I have allowed paging and set page size to 10..now I can see the 10 results in the first page and also see the page numbers at the bottom of gridview. But now when i click on the page 2, the method gridview_pageindexchanging is triggered but the result set is not dispalyed. My code is as below..
[code]....
i understand that the data is not binding in the GridView1_PageIndexChanging method..I do not know how can I make data bind..