ADO.NET :: General / Better Way To Write A Report?
Mar 15, 2011
i'm a new programmer, hope it's ok to ask this kind of general problem.
i don't know what it the general or better/best way to write a report?
it's a report of a financial system. lots of names, momey, amount, price, date, sum total... etc
like, [URL] (this is not mine, i just google "report")
i know i can use gridview/repeater... . use control and write sql command in it.
few days ago i heard some people will finish a report just in a store procudure! it looks better!
it doesn't include sql commands in .cs/.aspx file. i can separate sql command from c# codes! (finally!....)
so. question is, is this the best/better or most general way to write a report?
use store procedure? use sql user defined funcation? ....or ??
View 2 Replies
Similar Messages:
Apr 9, 2010
I'm looking for a way to output dynamic data into pdf report of my own customization, so I'm looking for some control to do it, anyone knows good one?
I need to be able to customize headers footers, add images and other cool stuff. so far I tried ItextSharp and Report.net, free libraries, but they lack documentation.
View 10 Replies
Feb 25, 2010
i am using .rdlc report .I have three fields like length,width ,height.I want to display Length X Width X Height.This is not multiplication .i want to show in a single column.
View 2 Replies
Nov 27, 2010
does windows azure automatically scale up(by providing more instances), or I need to change this?
the extra small instance costs 0.05$/hour. According to Azure SLA I need to use at least 2 instances. This means 2 * $0.05*24*30=$72/month minimum. I can get on premise asp.net hosting for $5/month. Is there any offer I don't know about so I can build from the start on Azure architecture, or should I just switch to azure when I need more scaling and other servies that Azure offers because the difference in price is too high for me.
View 3 Replies
Dec 21, 2010
I am using master page with content pages. I want to write a genral method to clear textboxes and for dropdownlist set index to 0. Please guide on this.
View 1 Replies
Dec 6, 2010
I'm searching for some extension methods that helps programming in ASP.NET. Some functions to work on controls, validators, AJAX or programing in C# in general.It could be methods library or your own methods.Do you know any source of those methods (other than CodePlex - that is good source of generic extensions) especially for ASP.NET?
View 1 Replies
Feb 17, 2011
I am converting a VB function into c#. I have this in VB: Dim Ret(2)
Whats the best alternative to convert this in c#?
View 4 Replies
Jun 18, 2010
or developing mobile web application based on the targetting mobile devices we can develop that in asp.net using asp.net controls but still so much of application they are using mobile controls in there project. mobile controls are not that much flexible but still why there are using? Is there any specific reason to use mobile controls in the project?
View 2 Replies
Jan 28, 2011
I'm making a visitor management application and I made three tables namely tblStudent,tblEmployee and tblVolunteer in SQL.I made a table according to the categories of a visitor.Do I still need to make a tblVisitor that would be the "general" table for the three tables made?I'm really confused whether it's needed or not to make a table to join similar attributes of student,employee and volunteer.
View 2 Replies
May 18, 2010
i have some web site with one page call genPage.aspx for all regular site pages, the title and the content of the page is changing by the pageId on the url (queryString). All the page looks the same (title, content and images and the same structure)im want to add contact form to the page with the pageId=7 only and dont have idea how to do this. (i know in classic asp it was : <if pageId = 7> html code and then <end if> but in asp.net i cant find the way. [Code]....
View 3 Replies
Aug 19, 2010
I have a web app that presents a list of statements pulled from the db to be ranked from "Never" to "Always" using a radioButtonList.
Some of the assessments have up to 100 statements, so I'm thinking that a ListView with paging and a RequiredFieldValidator for the radioButtonList would keep the presentation manageable.
I would like to submit the data after all of the pages are complete but I think that would require customization, or is my approach wrong?
View 4 Replies
Apr 19, 2010
I have a web service that I developed on my local machine using the Enterprise Library for database access and exception logging. This all works fine on my machine but not on my server. I get the following error and i do not know why. Tracing to LogSource 'General' failed. Processing for other sources will continue. See summary information below for more information. Should this problem persist, stop the service and check the configuration file(s) for possible error(s) in the configuration of the categories and sinks. I do not see any errors in the configuration. I can get it to log to a flat file but not to the event log or an email it is to send. This is on a Windows Server 2008. Is there any special permissions I need to set? I hope this is the correct place to post a message such as this, if not let me know where to post it to.
View 2 Replies
Jan 25, 2011
Is there a more general descripton of the sequence of events for a page loading
[Code]....
View 2 Replies
Nov 26, 2010
any plugin references for drawing flowchart or in general uml drawings with jquery ?
View 3 Replies
May 15, 2010
I am a newbie to ASP.NET (but not to C#)I have a project I am developing that may seem unconventional at this point but it is a project that I hope to eventually expand and provide a new type of service on the internet. Currently the project makes use of an Excel spreadsheet that is generated by another application I wrote. Basically the spreadsheet is an index to a specific type of file that exists on a host computer and the files are directly linked from within the excel document. When the link is clicked it opens the file using the operating system default program which then processes the file (this takes some time).
This is fine and dandy but when I click on another file, the default program immediately stops processing one file and opens the latest submission and thus interrupting the previous job. To prevent this I am now writing a queuing application. Here is where ASP.NET comes in. I do not want the link to open the queuing application with the file to add into the queue as a parameter because that pops one or more nnoying/scary "you are opening an executable" dialogs and because I want to be able to access the queuing service from a remote computer, and possibily in the future over the web. Instead I am trying to use an ASP.NET service application that will accept the name of a file as a parameter, access the external queue class (defined in an external dll of which only one universal instance is allowed), and add the request to the queue. Whether or not the table is an excel table or on a web page, using a form in this instance is tedious, not only for me but for a user. I want the user to be able to simply click on an html link and have the file be queued without anything except maybe a confirmation page pop up saying that the file has been queued and it will take x amount of time before the file is finished processing.
My problem is I cannot for the life of me find a way to do this. I have searched the interenet for over a week now looking for a way to call a "WebMethod" using a link and I am getting the impression that it cannot be done. Even when I use a form and try to have the form pass a string (representing the file name) as its "action" it comes up with an application error saying that I am missing the parameter I am trying to pass. Here are some examples of what I have tried:Here an example method I would try to access:
[Code]....
Here is an example of how I tried to access directly by way of a link (which results in an application error: InvalidOperationException)"
[Code]....
View 3 Replies
Apr 3, 2011
which is better approach from performance point of view, is it better to use one web-service method to load data by passing Database Table name and keys or is it better to use separate method for each database table! knowing that i'm using .net asmx through ajax requests.it's obvious that one method is better from OO perspective since it have one function type 'data loading' but what about performance? does IIS affected by that or not? also is it better to make multi web-services 'asmx files' or just one!
View 3 Replies
Oct 29, 2010
Order Table
Order No Date Product Qty Customer
A101 10-Oct-2010 Mac Book 10 John
A102 10-Oct-2010 I-Phone 25 Smith
A103 10-Oct-2010 I-Pad 40 Kallis
Here Order No is primary key
Order Detail Table
Order No Date Product Qty Customer Batch No
A101 10-Oct-2010 Mac Book 03 John B01
A102 10-Oct-2010 I-Phone 05 Smith B02
A103 10-Oct-2010 I-Pad 10 Kallis B03
A101 10-Oct-2010 Mac Book 02 John B04
A102 10-Oct-2010 I-Phone 07 Smith B05
A103 10-Oct-2010 I-Pad 15 Kallis B06
Here Batch No is primary key
The above table is just a sample table.
I have more than 1000 Order in my table. And for each Order there are at least 12 Order Detail is available in my Order Detail Table. It uses to take long time on loading the report for the first time. So, I thought to select Top 20 records from Order table. I have used the below query in crystal report command
Select Top 20 O.OrderNo, O.Product, O.Date, O.Qty,OD.Unit,OD.Rate from Order O
inner join Order Detail OD on O.OrderNo = OD.OrderNo
1. After execution of above query, I would like to know whether all the records from Order Detail Table will be checked during execution (OR) only matching Top 20 records of Order Table will be checked in Order Detail Table and executed?
2. How to use stored procedure in Crystal Report command?
3. What are the steps I need to take, to load Crystal report fast during first time page load?
View 1 Replies
May 28, 2010
I am trying to provision some users to update their email address in active directory (AD). I'm trying to achieve it using MembershipUser class. But getting 'general access denied error'. Here's my code:
string userName = "sathish";
System.Web.Security.MembershipUser userDetails = System.Web.Security.Membership.GetUser(userName);
if (userDetails != null)
{
userDetails.Email = "sathish@xyzee.com";
View 1 Replies
Mar 18, 2011
I am currently using DevExpress ASPxGridView and want the selection check box to show a redcross image on selection or empty when unselected. Is there any javascript library to do such a thing. If so can you provide me an example.
View 1 Replies
Feb 19, 2011
One of my table columns is for date and I understand how to use the ORDER BY statement in general. But how would I have the gridview sort with only the future items (relative to the current date) apear and leave out the past entries?
View 10 Replies
Feb 28, 2011
Coming from Java programming, I'm used to the general Main<->Test Maven-setup for a project. Whenever there's a new build, all tests will be run by Maven/Junit and I get feedback about them.
I've been looking around and I can't find an analogue way for ASP.NET and Nunit. Am I forced to put my UnitTest-classes in the APP_Code folder?
What's the general way to do this? Are there any recommendations for continuous integration?
View 1 Replies
Oct 1, 2010
Suppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
View 1 Replies
Mar 29, 2011
I am reading in a file into a string. Then I am writing this string to a stream. I know this code works fine.
The only problem that I have is with the line that write the data in chunks where the parameters is not supported for the Write method.
The line that has the problem is this line. What do I need to change here?
OutPut.Write(buffer, 0, Math.Min(to_write, WRITE_CHUNK));
[Code]....
View 2 Replies
Sep 20, 2010
we have a web application that one company prepared for us. this application read connection string from registery key in hkey_local_machine and connect to sql server 2005 database. It worked correctly in windows server 2003. we changed our Server'OS to windows server 2008. but we have a problem to login. after try to login we see this error: Server Error in '/dabir' Application. Login failed for user ''. The user is not associated with a trusted SQL Server connection. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Source Error:
[Code]....
Stack Trace:
[Code]....
View 4 Replies
Oct 6, 2010
i am calling a function which is inside Homescroll.ascx.cs from Homescroll.ascx so i wrote on Homescroll.ascx as <% Response.Write(scroll()); %> but all this is in update panel,and i am getting errors. so is their any other way to call function from homescroll.ascx to homescroll.ascx.cs,instead of response.write();
View 3 Replies
