ADO.NET - Raj Kaimal

Browse by Tags

All Tags » ADO.NET (RSS)

Uploading and storing files in SQL using ASP.NET

Version: VS2008 SP1 The sample code at the bottom of this post shows you how to upload files and store them in a binary column in SQL using ASP.net webforms and LINQ. S ee this post if you wish to upload an excel file, extract data from the cells and...
Posted by rajbk | 6 comment(s)
Filed under: , , , , ,

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. Edit on Feb 18, 2010 : To be clear, this method shows how to extract the contents of an excel file into a sql server...
Posted by rajbk | 20 comment(s)
Filed under: , , , ,

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 | 29 comment(s)
Filed under: , ,

What's the deal with Databinder.Eval and Container.DataItem?

Reposting here for the benefit of asp.net developers and Google The databinding expression <%# some expression %> is evaluated in the language of the page (VB, C#, etc.)   This can have a big impact on the current syntax, so be very careful...
Posted by rajbk | 75 comment(s)
Filed under: , , ,
More Posts