• About Ken
  • Ken’s CV

All About SharePoint

~ Liedong(Ken) Zheng, Independent SharePoint Consultant

All About SharePoint

Monthly Archives: March 2010

SharePoint 2010 Launch

18 Thursday Mar 2010

Posted by ken zheng in Uncategorized

≈ Leave a comment

It’s been announced! The SharePoint 2010 and Office 2010 launch will be May 12th 2010 and the RTM will be in April.

Advertisements

Removing SharePoint Survey Top Page Buttons

16 Tuesday Mar 2010

Posted by ken zheng in JavaScript, Sharepoint

≈ 2 Comments

Tags

Sharepoint, survey

I got request to remove the top buttons in the sharepoint survey to avoid user click next without scroll down the page. Below is the Javascript to do it.

var x=document.getElementsByTagName("input");
for (var i=0;i<x.length;i++)
  {
  if (x.item(i).type=="button"&&x.item(i).id.indexOf("top")>0)
     {
	if(x.item(i).value=="Save" || x.item(i).value=="Next" || x.item(i).value=="Cancel")
	{
		x.item(i).style.display = "none"
	}
     };
  }

Excel “External table is not in the expected format.”

14 Sunday Mar 2010

Posted by ken zheng in vs2010

≈ 1 Comment

Tags

Excel 2007, OLEDB

If you are using “Microsoft.Jet.OLEDB.4.0” to query Excel 2007, you may get this error.
“External table is not in the expected format.” typically occurs when trying to use an Excel 2007 file with a connection string that uses: Microsoft.Jet.OLEDB.4.0 and Extended Properties=Excel 8.0

Using the following connection string seems to fix most problems.

public static string path = @"C:\src\RedirectApplication\RedirectApplication\301s.xlsx";
public static string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";

Pages

  • About Ken
  • Ken’s CV

Blog Stats

  • 1,635,079 hits

.Net 3.5 5566 AJAX BCS BDC C# Calendar Content Type CSS Custom Page Document ID Fast Search favicon Feature IIS InfoPath infopath form JavaScipt JavaScript jQuery LINQ Listview Managed Property Master Page MCP MCPD migration MOQ MySite Page Layout PowerShell Proxy Search Search Scope SharePoiint 2010 SharePoiint 2010; Search SharePoin Sharepoint Sharepoint 2007 SharePoint2007 Sharepoint 2010 Sharepoint Search Silverlight Site Collection Site Definition Site Master Page site templates SPDisposeCheck SPD workflow SPSiteDataQuery SPUser SQL SSP stored procedure STSADM survey Tab TechEd Tech ED TSQL User Profile User Profiles Synchronization Service;SharePoint 2010 vs 2008 vs 2010 vs2010 WCF web.config webpart Web Part Web Service windbg workflow XML XSL XSLT

Archives

  • March 2016
  • April 2014
  • March 2014
  • February 2014
  • December 2013
  • October 2013
  • September 2013
  • March 2013
  • February 2013
  • August 2012
  • June 2012
  • May 2012
  • April 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008

Twitter Updates

  • @telstra @outage @3125 internet cable still not working since 8:30 am 6 months ago
  • @Telstra is internet cable service still down in Burwood Vic 3125? Have been issue for a day! 6 months ago
  • Anyone uses @Nintex Workflow for SharePoint online has email issue? all our external email actions are hanging since yesterday. 9 months ago
  • @Nintex Hi, is your Workflow External Email service is down? Since yesterday afternoon, no email being sent out usi… twitter.com/i/web/status/9… 9 months ago
  • @Nintex just wonder if there is any SharePoint online workflow server issue right now? All workflows are not reachable 1 year ago
Locations of visitors to this page

Blogroll

  • E-books Library
  • My Linkedin
  • SharePoint Community
  • SharePoint Developer Center
  • Silverlight Show
March 2010
M T W T F S S
« Feb   Apr »
1234567
891011121314
15161718192021
22232425262728
293031  
Advertisements

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy