Microsoft Talks Home


 

ADO.NET Connection Pooling at a Glance  Connection pooling can increase the performance of any application by using active connections of the pool for consecutive requests, rather than creating a new connection each time.And at the same time, the developer who is the best judge of his/her application, can configure the connection pooling.

Event Calendar  ASP.NET 2.0 Calendar Control customised to cater the requirement of tracking multiple days Events, project milestones, tracking history, tracking schedule etc.

Multiple Inserts in Single Round trip By Combining Inserts SQLs You can smartly append the Insert Statements and form a single SQL statement and use that as the command text for command object and execute.

Multiple Inserts in Single Database Roundtrip Using ODP.NET: ODP.NET provides us OracleCommand object which is quite similar to SQLCommand Object, just that, it supports taking arrays as parameters.

Multiple Inserts in Single Database Roundtrip Using ADO.NET Batch Update: ADO.NET 2.0 Adapter now supports multiple Insert/Update with the user defined UpdateBatchSize which determines the number of Inserts to be processed in one network round trip.

Multiple Inserts in Single Database Roundtrip Using SQLBulkCopy : With ADO.NET 2.0 we got the programming interface for Bulk Copy which provides quite simple and straight forward mechanism to transfer the data from one SQL server instance to another, from one table to another, from DataTable to SQL Server 2005 database, from DataReader to SQL Server 2005 database and many more.

Multiple Inserts by passing data in XML format to Stored proc: SQL Server 2000 supports XML. SELECT * FROM table FOR XML AUTO. Syntax sounds familiar, right? Yes, SQL Server 2000 supports XML. It not only supports returning the data in XML format, it also supports reading the XML string and parsing it. 

vbScript to Export to Excel 2007 :The HTMLProject is no longer supported in Office 2007, and with that the script we used to Export to Excel 2003 won't work. Here is the work around.

vbScript to Export to Excel 2003:Simple vbScript to Export to Excel 2003 using HTMLProject