How to do something like this without actually downloading the spreadsheet to the local machine? Any tools or what not out in the world for doing something like this? Does sharepoint allow for .xlsx editing in a page?
Anything short of writing all the inputs and mapping them with backend code?
I want to show information from an excel spreadsheet in a web page. The xls will have maybe 5 columns, and as many rows as needed. The columns will be 'Name', 'Created Date', 'Expired Date', 'Owner', and maybe down the road maybe more.
What I would like is for the C# to nightly read the xls, and display the information in a table on the website.
If there is a PDF available for download I am going to link that as well.
I have a requirement that the user will need to import a list of ID's to the asp.net website from their own spreadsheet. I will provide a button 'btnImport' which will use an OleDbConnection to read the spreadsheet and pull in the id's. I have that working fine in my local dev environment. My question is, when this app is running on a production server, will the user have to upload her spreadsheet to the server first? Or do I need to provide code that will find the file on her machine? I'm not sure how this part of it works.
View 4 RepliesMy question is that how to maintained page load time in c# and what page time load is good for site to crawl google index
View 1 RepliesI'm using MaintainScrollPositionOnPostback=true property but this doesn't seem to work with chrome. (works on IE),
Is there any other way to maintain scrool position without using this property?
I want to maintain the scroll position of a page. So I try to get the page cordinates and set the position on the page load (actually I've a postback in my page) using JS as follows. What I've done is on a client click on an image get the page cordinates and keep in a hidden field.
[Code]....
GetScollerPosition function invoke in an image click event. But it's not work as I expected, the SetScrollPostion always find the value of hidden fields as zero.
i have one listview with pager control as follows,
<asp:ListView ID="rgtListView" runat="server" DataSourceID="odjobs">
i have a master page that has a an accordion and inside the accordion is a cscading dropdownlist and then a button... Basically you select the values from the dropdowns and the click the button to change the content form from default.aspx to history.aspx. This works fine the first time I do it with the exception that cascadiing ddl all reset and then if i populate again and clcik the button again I get the following error(below)... I know I can set enableEventValidation = false, but wondered why this is occuring and what effect setting it to false would have? The second part of the question would be how do I maintain the ddl values when the page changes from default to History.sapx? I am using the following for the button.
<asp:Button ID="btnNewRecord" runat="server" Text="New" PostBackUrl ="~/History.aspx" />
Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true"
%> in a page.
For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.
I have some collapse able anhcor link tags on a page that reveal some text when clicked on i.e.: [+] Topic This is all done in javascript client side. I would like to maintain the users scroll position on the page when these links are clicked on. They dont cause a postback as iv mentioned above its client side javascript.
View 6 RepliesAfter working on a page for quite some time, the customer now decided that they wan't to be able to change a top level setting but still maintain the current page they're in.
Say for example:
User goes to default page, clicks on the UserSettings which is loading a partial view. In that partial there is multiple links like Address, Password, Other. Click Address (any of these) and it will load a partial within the partial. This will of course maintain the link "MyProject/User/1" in the URL bar.
When the User now change in the drop down in the top level, from User 1 to User 2 this will update the URL to be "MyProject/User/2" and will load the matching action with that. However, I wan't to be able maintain the user selection from before (MyProject/User/2, click UserSettings, click Address).
If I knew this from the beginning I would have done it completely different, but this now a request from the customer after the project is done so I'm look into if there is any "easy" way
[code]....
I can also add that I've tried to do something like this to figure out what exact page I'm on:
var foo = window.location.pathname;
but that only gives me what ever I already have in the URL bar, and not any information about what partial that potentially would be loaded. Is there any way to see what partials is dynamically loaded at the moment?
Basically loading View -> Partial View -> Partial View. Changing the setting for the View but still want to maintain View -> Partial View -> Partial View, but now for the new User
I am using accordion control in one of my project. I want to maintain the state of the accordion pane when the user navigates from one page to another. Below given is the code of my accordion control
I do not want to use query string because i am using url rewriting.
[code]....
I know how to keep track of the checkbox in a datarow, but I got no idea on keep tracking the checkbox state in the header rows.
For example, assume my gridview have 3 pages, after I check the checkbox in the header rows in 1st page, I click on 2nd or 3rd pages, and click back to my 1st page, my checkbox status in 1st page still remains checked.
How can I maintain gridview page index while navigating away from the form and getting back by either the browser's back button or custom navigation button?
View 1 RepliesI tried out the solution posted for [URL]
Is there any way to maintain scroll position if I need to re-direct to same page?
I have created a matser page with a two radio buttons, text box and a button. Whenever user sets some values to these control and clicks the button, i will navigating him from one content page to another based on the data he has entered. The problem is after the content page load, the values selected/given in the controls(radio button, text box) are getting cleared.
Is there some way to maintain the values ?
I have four controls in a page with update panel.Initially mouse focus is set to first control.when I partially post back the page to server the focus automatically moves to first control from the last focused control from the control I have tabbed down to.Is there any way to maintain the last focus?
View 1 RepliesHow to maintain Accordian history and user navigates to next page and trys to comeback to same page (where the accordian is). Its not actually a different page, but I am using asp multi view and Accordian in a view.
View 1 RepliesI use pagination for my datalist according to this link [URL].....
this is style of pagination
First 1,2,3,4,5 Last
when i run web site i see my datalist with pagination in webpage my datalist is middle of page when i click on page number 2 or 3 to see other page of datalist it reload page and go to top of page i should scroll until I can see my datalist again.
i want when users click on page number after that they see other page of datalist directly not top of page ..
I have some applications which I need to documentate. Is there any tool which could create UML or visio from my vb.net code?
View 3 Replieshow can i add dynamic control (like textbox) on asp.net page at runtime and maintain the values of the control (viewstate of control ) on client browser refresh or roundtrip?
View 3 RepliesI have a abc.aspx page having some control like (drop downs, text boxes), i am filling a grid based on selected items in the drop downs and date selected from the ajax calender extender control attached to the from data and to date text boxes.
Inside grid there is a link which redirects to bcd.aspx, this page (bcd.aspx) is having a back button to redirect abc.aspx.
Now what i want is, abc.aspx should main its state like grid, drop downs and text boxes should be shown as it was earlier, i.e. all should have same values as it was at the time of redirecting to bcd.aspx.
Yes, there is a way to maintain the state by passing all values from query string and than get all values back and rebind all controls. But i don't want to go this way because i will have pass so many values in query string.
While the economy has been in the shitter, I've written possibly the most coolest site EVER for unemployed developers looking to buzzword-ify their resumes. (Don't hate the player, hate the game.)
The only problem is, it needs a scheduled task to run once a day to do some data mining. I spent many, many hours a few months ago researching solutions, but nothing seemed sure-fire.
If I have shared hosting and cannot remote in (e.g. mstsc and create a Schedule Task), how can I create a task that will run once a day on the backend of an ASP.NET website?
After all the research I did, I don't think it's possible. Per my last analysis, someone has to visit the site at least once a day to instantiate an instance of HttpApplication.
Does anyone have any solution to making sure an operation runs automatically, no matter whether anyone visits the site, and without anything but FTP access to the website?
Like I said, I've done A LOT of looking into this in the past, and it didn't seem possible. IF YOU HAVE EXPERIENCE implementing a solution, contribute your advice! But not postulating or conjecturing needed--it's far more nuanced and difficult than you're surely imagining.
I have a short snippet of C# code like this:
HtmlGenericControl titleH3 = new HtmlGenericControl("h3");
titleH3.Attributes.Add("class", "accordion");
HtmlAnchor titleAnchor = new HtmlAnchor();
titleAnchor.HRef = "#";
titleAnchor.InnerText = "Foo Bar";
titleH3.Controls.Add(titleAnchor);
What I want is a way to return a string that looks like this:
<h3 class="accordion"><a href="#">Foo Bar</a></h3>
I think I already know the answer to this but I think you know more than me so best to ask :)I've got a basic .Net 3.5 site using C#, with no database backend.I've had a request for a function to be added to some forms for people to be able to save the forms and come back later to finish them off.Is this possible?I would think not without a database backend to save it too,
View 3 RepliesI have a two webpages,in my first webpage i have gridview with 8 pages(paging) and four coloumns.In fourth coloumn i have a link button to redirect tosecond webpage ,now i am in gridview 4 th page(paging) then i clicked the link button and move to second
second webpage.
second webpage contain one button that will redirect to first webpage.if i come from second webpage to first webpage the gridview paging get reset.but i want to be on gridview 4th page(paging).