I have huge excel files that I have to open from web browser. It takes several minutes to load huge file. Is it possible to open a single worksheet (single tab) at a time from excel file that contains many worksheets? I have to do this using C# / asp.net MVC
View 5 RepliesWe have a tab delimited file that we are making available for download. The file extension is txt, but the users want it to open automatically in Excel. The previous developer had used the following code:
[code]....
The ContentType is being set to Excel, but that doesn't seem to have any effect. I am guessing the txt file extension is causing it to be picked up by notepad or the like instead. I have tried just renaming it to a xls extension, which works but Excel complains that I am trying to trick it or it might be a corrupted file.
I tried simple code like this using href element. But it tries to open the sheet.xls in the browser window and says it can't find the file. I want the excel file to be opened in excel (not browser).
<a href="file://domainname/vol1/destinationfiles/sheet.xls" >some excel file</a>
I have a stored procedure that returns 3 tables within the single recordset it returns. If I set a SqlDataSource to get data from this procedure, it works, but it only returns the first table. I want to have a GridView display the data from the 2nd or 3rd table using a SqlDataSource, but I can't figure out how to specify a particular table.
While there are some posts discussing this out there, I can't get a definitive answer about whether or not this is even possible (?). In a worst-case scenario, I can create another SP that only returns the 3rd table - but that creates a little maintenance headache that I would prefer to avoid.
For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
I am trying something apart of my boundries, is there any way to disable a single intem in dropdownlist or stop the ddl change event for a single item.
View 2 RepliesI want to design a website wherein the page would be having 2 sections.
Section 1. Web page comming from other web site (this web page's domain may/ may not be the same wrt the website in which it would be getting displayed)
Section 2. Web page designed for this webSite
I don't want to use the IFrames for this purpose.
Further, the webpage from Section 2 would require the data from webPage of Section 1 (Interaction would be there)
We have a website where user registration is very specific to sub domains, i.e if you get registered as usera to sub1.sample.com, then you can register with same user name usera with sub2.sample.com
Now we are planning to implement OpenID. How can I restrict this behavior if OpenID is implemented?
how to prevent the two session on a single browser ie: first i opening a site on mozilla then login after logged in . I am opening a new table with the same url login using different user after that suppose there is one link called view my profile on user home page if if click the link on first tab browser, it showing the user details on second tab browser user details ie: previous session.how to prevent or avoid this ?
View 6 Repliesi have to open the popup on from the gridview's linkbutton, bnut it open on the double click, not on the single click.
LinkButton btn = sender as LinkButton;
I am trying to export just a table that is contained on my page. I have some filters above it but when exporting, all the text and filters are copied into this file.
This is the code:
tableCreateOrders a = new tableCreateOrders(dtReportColumns, 2, 10);
divResult.Controls.Add(a.displayTable());
Response.ContentType = "application/ms-excel";
Response.AddHeader("content-disposition", "attachment; filename=orders.xls");
Response.Write(a.displayTable());
a.displayTable() is the object containing the table, but the filters are defined on the .aspx so there is no way the command take it. Is there anything I am doing wrong?
We got a problem that Sessions got mixed up when open multiple tab in a single application. We could change the code that do not use session variable in a that level, but a tons of page need to be modified. We need to find a quick fix for this problem. Is any thing we can do in code level to prevent user open multiple tab in a single application? O any thing we can do to keep its own session for a single tab?
View 6 Replieswant to export 2 gridviews to 2 worksheets in single excel file. and also don't want to use any other dll or utility or Interop assemblies.
View 7 RepliesI have 25 collumn, i want export 20 collumn to sheet 1 and 5 collumn to sheet 2.
View 1 RepliesI need to open a excel in web browser when click a button.how to do that in asp.net
View 4 RepliesI have been asked to create import functionality in my application. I am getting an excel worksheet as input. The worksheet has column headers followed by data. The users want to simply select an xls file from their system, click upload and the tool deletes the table in the database and adds this new data.
I thought the best way would be too bring the data into a datatable object and do a foeach for every row in the datatable insert row by row into the db. My question is what can anyone give me code to open an excel file, know what line the data starts on in the file, and import the data into a datable object?
I have created a pdf file using aspose and need to open it without saving the pdf.Is it possible.
View 1 Replieswell I am trying to export sql data that has 80,000 records more than 65,000 rows which excel has.i do I export that much data in one trial without error.is it posible with bcp utility?
I tried DTS but did not work what option shall i use to define range in excel file to export data ?
I've been searching for various posts on Excel and ASP.Net, and wanted to try and figure out if what I'm attempting has any chance of working. I have a special Excel workbook with a worksheet that has a bunch of calculations and such for various fields that creates an order for his crew. My client uses this Excel worksheet for everything. He's asking me to be able to see online orders (which I have), click a link and have the worksheet be passed down to the client all populated and formatted exactly as is (just adding/editing data).
Is this even possible? I'd have to load this specific .xls file, then open it on the server, save data to various cells, and then do a Save As and then binarystream it down to the client. I'm quite certain there is no version of Excel loaded on the server. So I'm perplexed as to how to accomplish this. Has anyone encountered this situation before and been able to accomplish what's being asked?
am new to vb.net programming. i am trying to read an existing excel 2007 file from vb.net i used a form with single button and i written code in button click event
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
xlApp = New Excel.ApplicationClass
xlWorkBook = xlApp.Workbooks.Open("C:Documents and SettingsUSERDesktopd0805
[code]...
A blog user uploads pictures to a picture folder on the web server. Whenever the user deletes a post, any picture associated with the deleted post must also be deleted. Every post record is saved with its picture jpg name on the backend.
View 7 Repliesi have 2 dropdownlist to implement and the xml file is as follow:
<?xml version="1.0" encoding="utf-8"?>
<email>
<builderemail>
<builder id="1" value="builder@xyz.com">
</builder>
<builder id="2" value="Others">
</builder>.......
i am using visual studio 2005 and i tried to data bind each drop down list by choosing a data source. my requirements are that one of the drop downlist for builder's email and the other drop down list for manager's email. How do i do that by using the datasource configuration wizard?
Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 RepliesI am using Visual Studio 2005 version, DOTNET Framework 2.0, Technologies C#.NET and ASP.NET and Operating System WindowsXP.In my excel sheet i have two columns of data. Using Gridview i am retrieving data from excel sheet and presenting data. While i am writing RowDeleting event i am getting error primary key not exist.Below code i am using in my program: Default.aspx
View 2 RepliesI'm exporting the GridView to Excel. It works fine and I receive a prompt to Save/Open/Cancel the file although I need the file to be saved automatically in the provided (passed to the Export function) location and opened in the same browser window where the Gridview was.
View 2 Replies