My interested stuff(2008-08-03)

SQL

• Concatenating Row Values in Transact-SQL
• Backup SQL Server Databases  - cool looking stored procedure that will back up a database for you ... I'll have to check it out to see if it is better or would work better than my current cmd files using sqlcmd.

 Excel

• Creating Excel and Word reports for .NET applications using OfficeWriter

Add-in

• RockScroll FTW(非常酷，代替原来的代码滚动条)

• CSharp or Visual Basic class generator from XSD 

• DB Connection Visualizer

      

   

• Visual Studio 2003/2005/2008 Shortcuts Addin （不错的插件，添加常用文件的快捷方式）

•  Allocation SQL Server Management Studio Add-in

•   Export code as Code Snippet - Addin for Visual Studio 2008

•   NQuery!  （一个可以用SQL语句查询任何.net对象包括 arrays, data sets, data tables ） 

• 

Web

• A Small Design Study Of Big Blogs
• Links of Interest
• How to Encrypt Query String Parameters in ASP.NET
• 50个CSS创意例子。
• CSS圆角生成。
• How to easily enhance your existing tables with simple CSS
• 5 Useful Coding Solutions For Designers and Developers  
• Coquette - 一个非常不错的图标网站

Other

• Exporting DataGridView to Excel/Pdf/Image file by using Reporting Services report generation
• Extension Methods Roundup: Intersect, Union, AsNullable and GroupEvery
• a Tiny Parser Generator
• Must Have Software and Tools
• Via Alvin Ashcraft:  Phil Denoncourt has written a Visual Studio Add-in that integrates speech recognition with the Visual Studio environment.  He posted the installer and source on CodePlex.
• My Top 10 Source Code Search Engines
• Dynamically generating typed objects in .NET

 

How do I detect a session has expired and redirect it to another page

override protected void OnInit(EventArgs e)
  {
       base.OnInit(e);
if (Context.Session != null)
   {    if (Session.IsNewSession)
    {
    string szCookieHeader = Request.Headers["Cookie"];
     if ((null != szCookieHeader) && (szCookieHeader.IndexOf("ASP.NET_SessionId") >= 0))
     {
      Response.Redirect("sessionTimeout.htm");
     } 
    }
   }
  }