My goal is to create some Excel reports that users can download from my asp.net site. The data for the reports will come from an SQL database. I am using Visual Studio 2010 and the reports will be for Excel 2007.
View 2 RepliesUser's need to "download" an excel sheet with data.
However this sheet need to be created on the fly (user's can check of which data they want exported).
From the user's point of view, it will just be a link "Download Now".
From coding point of view I will have an IList<MyClass> where MyClass say got members like EntryId, FirstName, LastName etc.
I do not want all fields to be dropped into the sheet (so I will need control over that in my code)
This sounds like what I'm after (since I'll always only have one sheet)
Create an HTML document and save it with a .xls extension - Excel will open it and treat it like a native Excel file. This method is very simple and, of course, free - however, it won't allow you to have more than one worksheet in the Excel workbook...
I need to create a .XLS file and put it available for download in my .aspx page. this file is needed to have information from database. I'm using Linq to SQL. So I need a C# code for reading from DataBase using Linq and create a .XLS file for download.
View 1 RepliesI want to fill the database table in dynamically created Excel sheet through save dialog
View 1 RepliesI am developing a website and one of the requirements is that, application is showing millions of records in gridview and if client want to download it they can add that report to get generated in excel format and then they can logout after few hours they recive an email saying that their report is ready and they can download it.
View 1 Repliesknow diff between exporting in microsoft excel(97-2003) and microsoft excel(97-2003) data only.
View 1 RepliesI have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
View 3 RepliesIam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
View 2 RepliesI have master page, menu on master page, i use asp roles and trim menu item based on user roles and rights this process is working fine.
Now i have to create some reports based on user roles, and responsibility in a company like country head will view country wide reports, manager region will only view regional report and rest will view reports related to them.
How can i achieve this efficiently using asp roles.
I have an asp.net web app that uses forms-based authentication, a SqlMembershipProvider (using an encrypted password format), and a SqlRoleProvider. I need to know if it's possible to administer the users (create new users, assign them to roles, etc.) from a windows application - the powers that be don't want any administrative functionality in the web app itself.
Here is the membership provider definition from web.config:
[code]....
So, obviously, I have a Sql Server database that contains the users and roles for the web app. I'd like to create a separate windows app that references the web app assembly, and use the configured MembershipProvider, RoleProvider, and machineKey to create users, assign users to roles, etc. If that's not possible, I can duplicate the configuration settings from web.config within the windows app. But I don't know how to do this either.
[Code]....
after successful creation of 3 users on my web site now cannot create users
I have got two sets of users. One set can view all information of branches from 1to 5 and the other group can view all the information of branches from 6 to 10. How do I create reports using views for these two sets of users?
View 2 RepliesHow to Prevent PDF Document from Being download to users PC? it can be viewed on browser but should not download the file to PC.
View 4 RepliesI have an application through which sers make Requests, and the people who fulfill those requests can accept them, fulfill them, etc.When a Request has been submitted, the technician looks it over and if it's complete decides on whether or not to Accept it, which means he will now be assigned to it and working it.
View 6 RepliesDo we have any free 3rd party library that we can use in asp.net for download Excel sheets?
View 5 RepliesMy web service Return Files bytes Correctly .service Code is as Follows...
[WebMethod()]
public byte[] Download_Files_From_Database1(string File_ID)
{
try
[Code]....
when i hit url it gives required Output.but not using in above code
I want to allow users to download files that have names containing & characters.
We've escaped our way through the problem but cannot seem to get around one last obstacle.
Here in Download.asp.vb we have
Code:
[code]....
I am a newbie of handling memory.
in my web apps, files are stored as varbinary in sql server.
my goal is to make a response to let users to download the files.
if there is a file (500 MB) stored in one record in the sql server,
what is the best way to let users download it?
I found that , in code-behind, if the files are loaded as byte[] objects, it uses the memory.
for example, the datalength of a file in the database is 500 MB.
the byte[] for this file uses 500 MB memory. am I correct?
how about the filestream? if the file is loaded as a filestream object in code-behind.s
does it also take 500 MB memory?
I am trying to automate the creation of an excel workbook from data retrieved from a SQL server. I have successfully automated the process and the file successfully saves in a pre-determined location as a 57kb xlsx file. However, when I run the Response.TransferFile code, a file is downloaded that is 18kb in size, and when you try to open the file, it says that the file has an invalid extension. Here is the relevent code:
[Code]....
I have tried multiple content types and different ways of specifying the content type (Response.ContentType = XXX, Response.ContentType = "application/excel","vnd.ms-excel",etc). Nothing works. I can't figure out why the filesize is different even if the extension is wrong.
I can navigate to H:/test/filename and open it just fine, so the excel portion of the code is working fine. I don't understand because this code is so simple yet goes so horribly wrong.
I have a download which is in a class below
[Code]....
and on my page i have a download button which runs a webhandler like below
[Code]....
when the download button is clicked it runs the code below
[Code]....
the dtresults is a datatable that is created on the page. the problem i have is if the cell has commas in like '12 london road, london, le126yr' in the database then its putting it onto the next line in the exported csv file and treating it as a carriage return rather than keeping all on the same line. I have done a replace in the code to replace the comma's to replace them with nothing but it doesnt seem to be working.
I am generating an image using handler and showing that image on image control. Now I want to download same image which is generated using handler. In my handler, I am passing imagepath and one querystring and retrieving some data from database and watermark that content to my image. How to download that same image.
Code:
protected void Page_Load(object sender, EventArgs e) {
if (Request.QueryString.HasKeys()) {
string Code = Request.QueryString["Code"].ToString();
Session["Code"] = Code;
imgCoupon.ImageUrl = String.Format("ImageHandler.ashx?ImageUrl=" + Server.MapPath("Images/coupon.jpg") + "&Code=" + Code + "");
[Code] ....
I am creating Excel file from code. This code is working fine in my local server. because it is local iis and local VS. When I deployed in the server. I am not able to see (download) excel to client browser. How can we give access to see excel in client browser?
[Code]....
I have a series of reports that run off a one table. The problem is, I have to read in data from a flat file from a large data source in order to update my SQL table. Right now, I read the tables in then the last thing I do is truncate the table I report from, fill the table with the necessary data and run a few small stored procedures to update some of the fields. Then the users are ready to run their reports.
Is there a better way to do this or a way I can lock them out while the table is filling and updating?
Need to navigate to Excel spread sheet and display in the browser.
how could I do that ?
I have written code to export to excel as below:
View 2 Replies