Welcome to MSDN Blogs Sign in | Join | Help

October 2008 - Posts

Wednesday, October 29, 2008 4:11 PM

How to update an Excel worksheet using DataSet and the OleDbDataAdapter

One very convenient thing in ADO.Net is the DataAdapters. These give you an easy way to fill DataTables and DataSets, and also to update the backing data source with very little effort. However, in order to be able to do INSERT/UPDATE/DELETE you have
Posted by maspeng | 0 Comments
Filed under:
Thursday, October 09, 2008 12:56 PM

TCP connections hanging in the CLOSE_WAIT and FIN_WAIT_2 state.

The other day I had an interesting case, and since there was very little information about this, I thought I’d share it. The problem in short, a customer is running a web application that connects to SQL Server and very rapidly they were running out of
Posted by maspeng | 1 Comments
Filed under:
Tuesday, October 07, 2008 9:44 AM

Command prompt utilities, some resources in one place.

Sometimes there is some confusion on the different Command Prompt utilities. I will not go into detail on this, rather providing a collection of the online resources. The short summary is this: - ISQL is no longer supported, use SQLCMD - ISQL uses DB-LIB
Posted by maspeng | 0 Comments
Filed under: , ,
 
Page view tracker