I got my desktop completely format and re-install today. then i need to install all the
development tools and re-configure all the settings.
One of odd thing is the layout of the page looks disarray and very weird.
I checked that the reference path to the style sheet is correct, and it was working fine before.
I need to come back to the Windows Feature Configuration Window and make some turn on and off try, finally i got the solution that I must include the Static Content feature under Common HTTP
Features Section.
After I finish the change to enable this specific feature, the page layout looks the same as before
a blog to share Microsoft technologies Azure, DotNet, SharePoint, SQL Server,JavaScript Framework: Node.JS, Angular, React
Friday, July 27, 2012
Thursday, July 26, 2012
Connection String and Select Statement of Excel File in .Net Application
Microsoft provider two Data Provider to extract Data from Excel Files
the first one will have the connection pointing the folder or path that the file reside. the select command text will be select specific columns from the excel file.
the second provider will have the connection pointing the actual file and select command text will
be select all specific columns from the sheets in the excel file.
the first one will have the connection pointing the folder or path that the file reside. the select command text will be select specific columns from the excel file.
string ConnectionString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0} ;
Extended Properties=""Text;HDR=NO;FMT=Delimited;IMEX=1;"";", importPath);
string SelectRateCommandText = string.Format("select * from [{0}]",
Path.GetFileName(importFilewithPath));
the second provider will have the connection pointing the actual file and select command text will
be select all specific columns from the sheets in the excel file.
string ConnectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0} ;
Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1;"";", importFilename);
string selectCommandText = "select * from [Sheet1$]";
for the second option, when you work with it in asp.net web application,
you must upload the excel file the local temp folder first, then extract
the data.finally you can move it to the archive network folder. you can
directly pointing to the network folder and extract the data due to the
security issue.
Tuesday, July 17, 2012
Sharepoint 2013 or Sharepoint 15 Beta is available for the public
Microsoft announced the SharePoint 2013 Beta was available for public to download from TechNet
Download Microsoft SharePoint Server 2013 Preview
or you can directly download here
Direct Download SharePoint Server 2013 Preview
After you completed the installation of SP2013Beta and Visual Studio 2012 Ultimate RC
you must download the Development Tool for SP2013
Microsoft Office Developer Tools for Visual Studio 2012
Download Microsoft SharePoint Server 2013 Preview
or you can directly download here
Direct Download SharePoint Server 2013 Preview
After you completed the installation of SP2013Beta and Visual Studio 2012 Ultimate RC
you must download the Development Tool for SP2013
Microsoft Office Developer Tools for Visual Studio 2012
Thursday, July 12, 2012
How to Create Form Library for Publishing Site in Sharepoint 2010
when i create a site collection without creating the root in the web application
for example i have my publishing sharepoint site with this url
http://sp2012:33333/sites/MyPublishingSite/
Since this is a publishing site, by default, the InfoPath form service and Form library had been disabled. when i try to create a form library to store all the InfoPath form that I created for this site.
First i need to activate the Site Feature. Click on the Site Setting from the Site Action drop down menu.
then click on the Manage site features in the Site Actions Section.
then click on activate button to enable the Form Library in the publishing site.
After i successfully create the form library, then i want to publish the InfoPath Form to the library that i had created. when i launch the publishing wizard in the InfoPath 2010.
However I always encounter the following Error Messages.
when i use the root of the web application as the location Sharepoint or InfoPath Forms Service site.
then i will get this error. the root cause of this issue is that the root did not create after the web application is instantiate, since I only create a sub site collection under the sites
when i use the sub site to host the InfoPath form, i received "the following URL is not valid" error message. the root cause of this problem is that the InfoPath form can't be host on any sub site that the root site not being created.
after i google the web, the following link really help me figure out the root cause of all the issue.
Publishing Infopath To SharePoint: "the following url is not valid" Error
Subscribe to:
Posts (Atom)