ADO.NET - Raj Kaimal

Browse by Tags

All Tags » ADO.NET (RSS)
Saturday, May 02, 2009 4:59 PM

Uploading an Excel file to SQL through an ASP.NET webform

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. The sample code only shows how to import xls and xlsx files but it could easily be extended to support csv files...
Posted by rajbk | 3 comment(s)
Filed under: , , ,
Saturday, May 26, 2007 11:41 AM

Changing the connectionstring of a wizard generated TableAdapter at runtime from an ObjectDataSource

The Visual Studio 2005 Dataset designer allows you to create a DAL using a typed dataset and easily bind this to a GridView with the help of an ObjectDataSource. By default, in the TableAdapter generated, the visibility of the encapsulated Connection...
Posted by rajbk | 25 comment(s)
Filed under: , ,
More Posts