Reporting Services

http://msdn.microsoft.com/msdnmag/issues/06/06/DataPoints/default.aspx

Error Handling

http://www.15seconds.com/issue/030102.htm

Handler Session Timeout

Keep session alive
http://www.codeproject.com/aspnet/Session_Defibrillator.asp

Detect session timeout
http://www.codeproject.com/useritems/Detecting_Session_Timeout.asp

Keep session alive
http://www.codeproject.com/aspnet/Reconnect.asp

Ever wanted to have a web application whose session variables never expire
http://www.codeproject.com/useritems/SessionRefresh.asp


A Session Data Management Tool
http://www.codeproject.com/aspnet/sessiontool.asp

Page Tracking in ASP.NET
http://www.codeproject.com/aspnet/PageTracking.asp

Automatically Saving Web Form Data
http://www.codeproject.com/useritems/AutoSaveFormData.asp

Session management options in ASP.NET
http://www.codeproject.com/aspnet/ASPNETSession.asp

Design References

http://www.codeproject.com/aspnet/ModelViewController.asp

SQL Server 2005 diagram problem

The following error will happen if the database compatibale level is not 2005.

Database diagram support objects cannot be installed because this database
does not have a
valid owner. To continue, first use the Files page of the Database
Properties dialog box or
the ALTER AUTHORIZATION statement to set the database owner to a valid
login, then add the
database diagram support objects.

To create database diagrams, change the database compatibility level to
2005, install database diagram support, and then return the database to the
desired database compatibility level. For more information, search for
"sp_dbcmptlevel" in SQL Server Books Online.

Insert data into sql server from xml

ref: http://www.codeproject.com/database/openxml.asp

Tool to build regular expression

http://www.codeproject.com/dotnet/expresso.asp

Issue for importing excel sheet to SQL Server

When the Jet Provider determines that an Excel column contains mixed text and numeric data, the Jet Provider selects the "majority" data type and returns non-matching values as NULLs.For additional information about how to work around this problem, click the article number below to view the article in the Microsoft Knowledge Base:

http://support.microsoft.com/kb/194124/EN-US/

Resolution:

There are two workarounds for this behavior:
1. Insure that the data in Excel is entered as text. Just reformatting the Excel column to Text will not accomplish this. You must re-enter the existing values after reformatting the Excel column. In Excel, you can use F5 to re-enter existing values in the selected cell.
2. You can add the option IMEX=1; to the Excel connect string in the OpenDatabase method. For example: Set Db = OpenDatabase("C:\Temp\Book1.xls", _
False, True, "Excel 8.0; HDR=NO; IMEX=1;")
3. Select the entire column and go to Menu Item "Data -> Text to Column" Click Next, then select the column data format as Text, then click finish. The entire column should convert to text format.


NOTE: Setting IMEX=1 tells the driver to use Import mode. In this state, the registry setting ImportMixedTypes=Text will be noticed. This forces mixed data to be converted to text. For this to work reliably, you may also have to modify the registry setting, TypeGuessRows=8. The ISAM driver by default looks at the first eight rows and from that sampling determines the datatype. If this eight row sampling is all numeric, then setting IMEX=1 will not convert the default datatype to Text; it will remain numeric.

You must be careful that IMEX=1 not be used indiscriminately. This is IMPORT mode, so the results may be unpredictable if you try to do appends or updates of data in this mode.

The possible settings of IMEX are: 0 is Export mode
1 is Import mode
2 is Linked mode (full update capabilities)


The registry key where the settings described above are located is:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Excel

See the REFERENCES section of this article for information on when the Excel spreadsheet has text column headers with numeric data.

Import Excel to SQL Server: http://support.microsoft.com/kb/321686

Dataset join view

How to create dataset join view

http://support.microsoft.com/kb/326080