Explore the code as you learn to create a BDC model that uses BCS entities in Visual Studio to access a matrix in SQL Server. Author: Martin Harwar (Other)
Sample: Creating a .NET Connectivity Assembly for Business Connectivity Services by Using Visual Studio 2010
In a previously post I wrote about how we can retrieve data from a SQL Server Compact Edition (SSCE) database with ADO and Excel.
Here is the original post:
Create SQL Server Compact Edition Database with VBA
The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.
Read more here:
Microsoft® SQL Server® 2008 R2 Feature Pack
Today’s guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . Excel 2010 is coming and your boss and peers might soon start asking questions about Business Intelligence and Data Mining. This leaves the Access professional looking a little behind the times unless you adapt to this new area.
In our last blog of this series Walkthrough of creating a SharePoint 2010 external list using Visual Studio 2010 Beta , we introduced how to create a simple “Hello world” external list in SharePoint 2010 Beta using Business Data Connectivity Designer in Visual Studio 2010 Beta. In this blog, we will show you how to pull data from an external database into an external list and enable Create, Read, Update and Delete (CRUD) functions to the external list.
Here is the original:
Walkthrough of enabling CRUD for SharePoint 2010 external lists using Visual Studio 2010
To create a workable structure I have always grouped individual new versions of Windows, VS.NET, VSTO and Office together.
The New Package; Windows 7, VS.NET 2010 and Office 2010