Friday, July 27, 2012

How to fix CSS Style unable to load in asp.net web application hosting in Local IIS

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

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.

 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

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