Step-by-Step: Installing SQL Server Management Studio 2008 Express after Visual Studio 2010

UPDATE 7/31/2012 – Since this post new versions of SQL Server & Visual Studio have been released. To install the latest version of SQL Server see SQL Server Install. For more information on working with SQL Server Local DB in Visual Studio 2012 see Working with SQL Server LocalDB in Visual Studio 2012 and the MSDN… Read more

Quickly Import and Export Excel Data with LINQ to XML

One really handy thing to do with relational data is to import and export it to Excel. This can be a total snap using LINQ to XML in Visual Basic 2008. For example, let’s say I want to import data from an Excel spreadsheet into a local database file like SQL Compact Edition. I also… Read more

Forms Over Data Video Series – Two More Videos Released

I just released two more videos (#15, #16) in the Forms Over Data video series. One is on understanding data binding and how it works from database all the way to the controls you see on forms. We talk about the relationship between the TableAdapter, the BindingSource and the DataSet and I show how to work… Read more

Using Microsoft Word to Create Reports For LightSwitch (or Silverlight)

Note: This post has been updated for Beta 2 on 3/24/2011 LightSwitch has a really nice feature on data grids that allow you to export them to Excel if running as a Desktop application (out of browser). This gives you a basic way of getting data out of the system to create reports or do… Read more

The New TableAdapterManager in Visual Studio 2008

In my previous post on TableAdapters and Transactions I showed a couple techniques on how to perform hierarchical updates inside a transaction when you have multiple related DataTables in your DataSet. The example I gave here shows how to use database transactions or the TransactionScope to update your data properly using Visual Studio 2005. It… Read more

Understanding .NET 2015

Last year after BUILD I posted Exciting Times for .NET and since then I have had the pleasure of working much closer with the .NET team, which includes the runtime, framework, languages & compilers. Although my focus has been a lot more on internal community in the last year, such as helping run internal conferences… Read more

Deployment Guide: How to Configure a Web Server to Host LightSwitch Applications

Note: This information has been updated since original posting and now applies to Visual Studio LightSwitch 2011 RTM. For information on deployment enhancements with LightSwitch in Visual Studio 2012 (LightSwitch V2) please see LightSwitch IIS Deployment Enhancements in Visual Studio 2012. Visual Studio LightSwitch applications are logically three-tier applications and consist of a client, application… Read more

Using TableAdapters to Insert Related Data into an MS Access Database

I’ve posted before about how to use TableAdapters to update parent-child (master-detail) relationships against SQL server. It’s pretty straightforward and Visual Studio generates all the code for you to properly insert, update and delete your data. However if you’re using MS Access then there’s one thing that Visual Studio doesn’t do because it’s not supported… Read more

One-To-Many (Master-Detail) Forms with LINQ to SQL

In previous posts this month I showed how to use LINQ to SQL classes with a couple different Combobox data binding scenarios. (You can read those articles here and here.) Today I’m going to show you how to create a one-to-many data entry form (and we’ll use a couple Combobox lookup lists as well). I’ll show you… Read more

Enabling Remote SQL Express 2008 Network Connections on Vista

Today I spent way too long trying to enable remote network connections on my SQL 2008 Express database running on my Vista development machine so I thought I’d post the steps here. Please note that these settings may NOT be appropriate for your production environments. I’m a developer ;-), hence this is what I did… Read more