Sharepoint - Display An Excel 2010 Document In A Web Application?
Jul 12, 2010
I am wanting to display an excel 2010 document in an asp.net web application. This document uses the new slicer functionality which I want to be available to the user.I know that excel 2010 docs can be used within sharepoint by inserting a web part which uses exceservices.But can it be achieved without sharepoint? Or can it be achieved using the the excelservices API to get the document from shreapoint and then somehow get it to the browser in .net?
View 1 Replies
Similar Messages:
Sep 9, 2010
Being new to integrating sharepoint documents into web applications I am struggling with the following task, so anyI have a page in my web application that needs to display a document from sharepoint.I use the appropiate sharepoint web service to get a list of all the documents in the sharepoint list, I then pick out the one I would like to retrieve and get the path to the document so i would end up with something like:
Company%20Hire/Hire%20Site%20Price%20Lists/0.pdf
Within our network I can do following:
iframePdf.Attributes[
"src"] = ConfigurationManager.AppSettings["SharepointUrl"] + _filePath;
This would display the document in iframe... problem I have is coming from outside the network the sharepoint site can't be accessed (due to firewalls etc). We do have a vpn back to our network on the external server our web application sits on. If i was to use the document url in a browser on the server I am prompted for credentials and then get to view the document.Is there a way for the web application to use the vpn, use credentials i give (e.g through impersonation) to access the document and display it to exernal clients?
View 2 Replies
Sep 18, 2011
how to integrate my asp.net application to sharepoint 2010?
View 3 Replies
Aug 2, 2010
Suppose I created a custom web application that consists of: several assembly DLLs: web app, business logic, data services multiple aspx pages and ascx custom controls that use them custom configuration section custom HTTP module. More or less the usual stuff. I would like to deploy it to a particular sharepoint site under a certain subfolder. So if I access my sharepoint site via [URL] (because I'm not using sites/some_site) I'd like my application to be available under [URL]
I could manually add a virtual folder (not application because I would need to access some Sharepoint site's data) to my sharepoint site in IIS and manually edit site's web.config file to register my HTTP module and add my custom configuration section as well either putting my DLLs into GAC or put them in the _app_bin (so I don't have problems with CAS), but I don't think that's a good thing to do, because this web application may get deployed in an environment where this shouldn't/couldn't be possible. So I figured I could build a WSP using Visual Studio 2010 and deploy it that way. But I don't have enough experience doing that.
I created a new sharepoint 2010 project. Is there a way I could add all non-executable application files (aspx, ascx) at once? I've seen the advanced tab of the WSP package where I can add my DLLs either to bin folder or GAC. I don't know whether I would also have to add any safe control and register certain classes?So I suppose I need some pretty detailed and explanatory guidance here.
View 1 Replies
May 26, 2010
I am working on a Custom WebPart, for which I need an application page to render a PDF file.
I am currently using following link [URL]
It works fine in ASP.NET, but gives a blank page in SharePoint.
Here's the code:
(PDF file is in same directory)
Response.ClearContent();
Response.ClearHeaders();
//Set the appropriate ContentType.
Response.ContentType = "Application/pdf";
//Get the physical path to the file.
string FilePath = MapPath("Test.pdf");
//Write the file directly to the HTTP content output stream.
Response.WriteFile(FilePath);
Response.Flush();
Response.End();
View 1 Replies
Jan 31, 2011
In a VB.Net project I use the Adobe PDF Reader (AxAcriPDFLib) control to display a preview of a selected PDF document whereafter the user can double-click upon the selected listbox item to enjoy a full screen view of the relevant PDF document. see the attached sample in this regard. Is there any way to emulate this in ASP.Net?
View 5 Replies
Jun 15, 2010
Following error comes when creating a WebPart In sharePoint 2010 Server.
Web Part Error: Unhandled exception was thrown by the user code wrapper's Execute method in the partial trust app domain: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.TypeLoadException: Could not load type 'Microsoft.SharePoint.WebControls.SPGridView' from assembly 'Microsoft.SharePoint, Version=14.900.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. at ListMenuSample.ListMenuSample.ListMenuSample.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.ExecuteHttpRequest(SPUserCodeWebPartHttpRequestContext webPartExecutionContext, SPUserCodeWebPartHttpResponse httpRequestResponse) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.Execute(SPUserCodeExecutionContext executionContext) at Microsoft.SharePoint.UserCode.SPUserCodeApplicationHostAppDomainRef.Execute(Type userCodeWrapperType, SPUserCodeCachedAssemblyGroup userAssemblyGroup, Guid siteCollectionId, Byte[] binaryUserCodeToken, Byte[] proxyOperationToken, SPUserCodeExecutionContext executionContext)
View 1 Replies
Apr 29, 2010
how to adding a file to the sharepoint document library? I found some articles in net. but i didn't get the complete concept of the same. Now i uploaded a file without metadata by using this code.
[Code]....
This code is working as fine. But i need to upload file with meta data. I created 3 columns in my Document library..
View 3 Replies
Apr 16, 2010
I want to build a custom document management web application that ties in with sharepoint for the actual document versioning and storage. I'm hoping for something like a sharepoint widget that I can plug into my web application that would allow me to tie in with sharepoint and download documents, make edits to them, and upload them back to sharepoint, with sharepoint handling all of the versioning and storage. Basically I'm looking for a sharepoint API. If WSS is the answer to this, are there licensing issues that I need to consider?
View 4 Replies
Feb 15, 2011
I am creating one new silverlight webpart from VS Sharepoint 2010. If i am creating the silverlight application its asking for the sharepoint local site url, i gave the valid url but its showing the ["could not contact sharepoint server for list of document libraries. check your sharepoint URl"].
how to resolve this error.
View 1 Replies
Feb 22, 2010
I am using webclient object to download a file to a windows folder from a sharepoint document library. The credentials I am passing to the webclient object are that of site collection administrator. everything works fine while i test it by uploading a file to the document library. But since the document library is email enabled; when an email is received the file is not transferred to the windows folder. i have put some workflow history events to see which user account is used when the email is received. the user account shown is the network service account. I have given write permissions on the folder to all the users; Everyone, Network service, the site collection administrator user etc. but still i cant figure out what is the problem.
View 2 Replies
Apr 5, 2010
We have created an ASP.NET web app that upload files to WSS Doc Libary. The files get added under 'SYSTEM ACCOUNT' in the library. The FullTextSqlQuery class is used to search the document libary items. But it only searches files that has been uploaded by a windows user account like 'Administrator' and ignores the ones uploaded by 'SYSTEM ACCOUNT'. As a result the search results are empty even though we have the necessary data in the document library. What could be the reason for this?
The code is given below:
public static List GetListItemsFromFTSQuery(string searchText)
{
string docLibUrl = "http://localhost:6666/Articles%20Library/Forms/AllItems.aspx";
List items = new List();
DataTable retResults = new DataTable();
SPSecurity.RunWithElevatedPrivileges(delegate
{
using (SPSite site = new SPSite(docLibUrl))
{
SPWeb CRsite = site.OpenWeb();
SPList ContRep = CRsite.GetListFromUrl(docLibUrl);
FullTextSqlQuery fts = new FullTextSqlQuery(site);
fts.QueryText =
"SELECT Title,ContentType,Path FROM portal..scope() WHERE freetext('" +
searchText +
"') AND (CONTAINS(Path,'"" +
ContRep.RootFolder.ServerRelativeUrl + ""'))";
fts.ResultTypes = ResultType.RelevantResults;
fts.RowLimit = 300;
if (SPSecurity.AuthenticationMode != System.Web.Configuration.AuthenticationMode.Windows)
fts.AuthenticationType = QueryAuthenticationType.PluggableAuthenticatedQuery;
else
fts.AuthenticationType = QueryAuthenticationType.NtAuthenticatedQuery;
ResultTableCollection rtc = fts.Execute();
if (rtc.Count > 0)
{
using (
ResultTable relevantResults =
rtc[ResultType.RelevantResults])
retResults.Load(relevantResults, LoadOption.OverwriteChanges);
foreach (DataRow row in retResults.Rows)
{
if (!row["Path"].ToString().EndsWith(".aspx"))
//if (row["ContentType"].ToString() == "Item")
{
using (
SPSite lookupSite =
new SPSite(row["Path"].ToString()))
{
using (SPWeb web = lookupSite.OpenWeb())
{
SPFile file = web.GetFile(row["Path"].ToString());
items.Add(file.Item);
}
}
}
}
}
} //using ends here
});
return items;
}
View 1 Replies
May 18, 2010
I want to export sharepoint list to excel, I also posted question on another sharepoint forum(http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/f890abb6-5558-4e47-925e-e1a026804d58)
View 2 Replies
Oct 21, 2010
When I open an Excel file stored on Sharepoint, I have the option to open it Read Only or in Edit mode. If I open it Read Only, Excel opens up and I see "Server Workbook To modify this workbook, click Edit Workbook". I need to retrieve this Excel file through an ASP.NET application, yet still have this Server Workbook functionality.In fiddler, I see that when opening up in Sharepoint, a POST is made to SharepointSite/_vti_bin/_vti_aut/author.dll with method=getdocument as one of the parameters sent and the filename as another.Do I need to repeat that POST via an ajax call or is there an easier way (as I suspect there is)?
View 2 Replies
Jun 22, 2010
I am currently working on creating a ModalPopUp for SharePoint Web Part.I am facing compatibility issues with ModalPopupExtender (with IFrame).
What are the other options available in SharePoint 2010 or ASP.NET for getting a Modal Popup?
Note: I have tried ModalPopupExtender and OpenModalDialog.
View 4 Replies
Mar 21, 2011
using SqlProfileProvider with sharepoint 2010
View 2 Replies
Jun 29, 2010
Is a sharepoint 2007 webpart likely to work on 2010 without any modification? If not, what are the main areas that would require modification?
View 3 Replies
Feb 15, 2011
I've searched some FREE Controls, Templates, WebParts, Themes for SharePoint 2010, and its really hard to find good and free examples. Turned back into StackOverFlow and there is no Community Wiki for it. I want to open a Community Wiki about All Free SharePoint 2010 Controls, Templates, Themes, WebParts, etc... to collect them all in one topic.For example, there is a site about MOSS 2010 Free Controls in here. This site containt most MOSS versions controls, web parts. I want SO Users to add most usefull web sites for SharePoint 2010 Developers such as Free controls, themes, tools, etc.
View 1 Replies
Mar 8, 2011
I am working on SharePoint 2010. I need to send email with attachments using aspx and c# code.
how to do this?
View 2 Replies
Oct 13, 2010
I would like to create and deploy an ASP.NET web form on SharePoint server which can create document in SharePoint list (or library). Since I'm not experienced in both these technologies so would appreciate if someone guides me to the right tool. Should I use Visual Studio or SharePoint designer ? Also, I was reading an article on MSDN about "Deploying ASP.NET Web Applications in the Windows SharePoint Services 3.0 _layouts Folder". Is it the best practise or should I go with webpart/solution based deployment?
View 1 Replies
Mar 2, 2011
I've tried to use Ajax Control Tool Kits on SharePoint 2010 Web Site, but Im having some trouble with registration. I've searched a lot on google for a solution. I've found some ways, but my problem is not solved. When I open my web site, still getting registration error.The problem is registration of Ajax Tool Kit. Here is my steps.1 - Downloaded Ajax Control Tool Kit latest version.2 - Added following line to my page
<%@ Register Assembly="AjaxControlToolkit, Version=3.0.30930.28736, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
3 - Added following line to my master page (v4.master)
<%@ Register Assembly="AjaxControlToolkit, Version=3.0.30930.28736, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
4 - Replaced this tag
<asp:ScriptManager>
with
<ajaxToolkit:ToolkitScriptManager>
but problem not solved.. Still getting same registration error. I need your suggestions about implementing Ajax Control Tool Kits on Share Point 2010.
View 1 Replies
Jul 16, 2010
I am having issues with the AjaxControlToolkit.I started with the 3.5 version and backed up hoping for some love but I am still stuck in quiet desperation trying to meet my impossible deadline.I have changed my masterpage to use the ControlToolkitScriptmanager.System.Web.Extensions references v3.5.0.0 throughout the config.Version of the toolkit referenced in the VS2010 webpart project verified as 3.0.30930.28736
The issue is that no matter what control or extender I try to use I receive the following error:
The base class includes the field '(control/extender name)', but its type (AjaxControlToolkit.(control/extender)) is not compatible with the type of control (AjaxControlToolkit.(control/extender)).
If it would help I would post the entire web.config.If anyone has a working setup with a version of the toolkit I would love to get a copy!I will have to get Silverlight going next.
GAC:Microsoft (R) .NET Global Assembly Cache Utility.Version 4.0.30319.1
Copyright (c) Microsoft Corporation.All rights reserved.
The Global Assembly Cache contains the following assemblies:
ajaxcontroltoolkit, Version=3.0.30930.28736, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e, processorArchitecture=MSIL
Number of items = 1
--
MasterPage (excerpt):
<%@ Register TagPrefix="asp" Namespace="AjaxControlToolkit" Assembly="AjaxControlToolkit, Version=3.0.30930.28736, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e" %>
[code]...
Environment:Visual Studio 2010 SharePoint 2010 (clean install) Windows Server 2008R2
View 8 Replies
Aug 1, 2010
As part of our branding of Sharepoint 2010, we'll be modifying some custom HTML menu's based on database and user permissions.
To do this, we are looking at the use of code-behind in a custom Sharepoint 2010 master page.
The only reference I can find to creating a code-behind file for sharepoint 2010 is this blog post series. The issue I have with this is that it's using the Visual Studio 2010 Sharepoint integration, which has the genius feature of requiring a local instance of an entire Sharepoint site. This isn't something that I can do/get.
This is the MSDN for code-behind master pages in Sharepoint 2007. I'm assuming it's similar but I can't find anywhere that describes it as such.
Is deploying a code-behind for a custom master page the same as in Sharepoint 2007 or does anyone have any experience doing this?
View 1 Replies
Apr 4, 2012
It cant be more simple. However I have tried a lot of examples and none of them have been working.
I have a very simple Excel file. I want to post these data in a gridview, Column A, B and C all placed in the Sheet1 and the file name is Book1.xls.
View 2 Replies
Jan 20, 2011
I have the following code which works well on my local machine, but when I deploy it to Sharepoint 2010 the jquery doesnt work... the calender control doesnt pop up when the web page is added to Sharepoint.
[Code]....
View 3 Replies
