Raj Kaimal

The method below describes how to upload a file to a webserver and then import the file into SQL using either LinqToSQL or SQL Bulk Copy.

Edit on Feb 18, 2010 : To be clear, this method shows how to extract the contents of an excel file into a sql server table as columns. This is not about uploading an excel file and storing it in SQL binary column.

The sample code only shows how to import xls and xlsx files but it could easily be extended to support csv files too.  Sample code is attached at the bottom.

Version : Silverlight 2 Beta 2

I decided to try out Expression Blend 2.5 beta by creating a four stroke engine animation. A screen capture is shown below:

Read the Post that goes with this Demo over here

Version : VS 2008 RTW

When you have a team working on a project that contains a LINQ to SQL class (dbml), you might see the following message when trying to add a Table entity or stored procedure in a dbml created by a fellow developer:

The objects you are adding to the designer use a different data connection than the designer is currently using. Do you want to replace the connection used by the designer? 

The reason this happens is because the connection string in Server Explorer used to add the new stored procedure is different from what was originally used. In a team environment, this will occur if one developer checks in the dbml using one connection string and another developer checks out the dbml and tries to add a stored procedure or a table using a different connection string. Connection strings generally fall into one of the two shown below for SQL server:

Prerequisite: LinqDataSource & SqlDataSource Master/Details

Paul Andrew has posted a link to the .NET framework 3.5 commonly Used Types and Namespaces poster - cool stuff!