Is there a way on Sharepoint 2007 to track stats. I have been asked to see how many hits a certain page gets. Can this be done on individual pages or sigle documents.
View Complete Post
I am trying to simply extract an excel data from an uploaded file an put it into a datatable. In this case the excel file has 3 rows but when I fill the datatable I only see row count of 2.
I tried changing HDR:NO; to HDR:YES and vice versa, but no luck.
What am I doing wrong? (Note: the excel file cannot have a headerrow)
string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pFilePath + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR:NO;\"";
OleDbConnection conn = new OleDbConnection(connstr);
DataTable dtTables = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
string strTablename = dtTables.Rows["TABLE_NAME"].ToString();
string strSQL = "SELECT * FROM [" + strTablename + "]";
OleDbCommand cmd = new OleDbCommand(strSQL, conn);
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
//At this point row count=2 which doesn't make sense
few Days Back I was Invloved In a project Which was Migration VBA in Office Word 2007 to C#..
I faced Loads Of Problem (I am was Very new to Word VBA)..
So I Decided To Migrate
the above VBA Book
I have Migrated Concept and collection Section...
Hope It help SomeBody Like Who was Struggeling to Migrate VBA to VSTO
I want to develop an application which supports Server Side Excel Automation using a template(xltx). I am able to acheive most of the automation except(using excelpackage.dll - OfficeOpenXml), i am stuck up identifying the checkbox controls in my excel work sheet.
Any help on this is really appreciated.
My sample code.
I am using .net version 1.1 and excel 2003 to display data.I need to display data in 2007 .Can anyone suggest the reference to be added ,connection string change and what should be imported.
Custom field types provide a powerful way to define a reusable SharePoint column definitions.
MSDN Magazine May 2009
Learn how to automate custom SharePoint application deployments, use the SharePoint API, and avoid the hassle of custom site definitions.
E. Wilansky, P. Olszewski, and R. Sneddon
MSDN Magazine May 2008
Speech Server 2007 lets you create sophisticated voice-response applications with Microsoft .NET Framework and Visual Studio tool integration. Here's how.
MSDN Magazine April 2008
LINQ to XML and the Microsoft SDK for Open XML Formats simplify access to the parts of a 2007 Office system Open XML document when retrieving or modifying data, resulting in shorter, less complex code.
MSDN Magazine March 2008
This month Ted Pattison presents an overview of programming security and permissions for Windows SharePoint Services 3.0.
MSDN Magazine February 2008
Windows SharePoint Services (WSS) 3.0 provides a new and improved infrastructure for handling server-side events. In this installment of Office Space, we look at techniques for hooking up Before Events and After Events using both Features and code.
MSDN Magazine November 2007