Combining Css and javascript into one http request in ASP.NET 2.0.

We always include many javascript and css file into our page.aspx file,


here is code that combined all javascript into one javascript and all CSS into one CSS  using a handler.
here is steps for doing so....


make a handler named HttpCombiner.ashx into your root directory.


//HttpCombiner.ashx



<%@ WebHandler Language="C#" Class="HttpCombiner" %>


using System;
using System.Net;
using System.IO;
using System.IO.Compression;
using System.Text;
using System.Configuration;
using System.Web;


public class HttpCombiner : IHttpHandler {
    
    public void ProcessRequest(HttpContext context)
        {
        // Get the list of CSS files from QueryString.
        string files = context.Request.QueryString["fileName"];
        if (string.IsNullOrEmpty(files))
            {
                return; // If no file name is mentioned then don't proceed.
            }


        // Get the list of files specified in the querystring (joined by ',').
        string[] arrFileNames = files.Split(',');
        if ((arrFileNames != null) && (arrFileNames.Length > 0))
            {
            string filePath = string.Empty;


            // Read the content of each CSS file and write it in the response.
            for (int fileCount = 0; fileCount < arrFileNames.Length; fileCount++)
                {
                filePath = context.Server.MapPath(arrFileNames[fileCount]).Trim();
                if (File.Exists(filePath)) // Check if the file exists in the physical location or not.
                    {
                        context.Response.Write(File.ReadAllText(filePath));
                    }
                }
            //context.Response.ContentType = "text/css"; // Set the content type.
            }
        }


    public bool IsReusable
    {
        get
        {
            return true;
        }
    }


}


Add the following code into your .cs file for CSS...



HtmlLink htmllnkcss = new HtmlLink();
        htmllnkcss.Href = "HttpCombiner.ashx?fileName=themes/css/abc.css,themes/css/xyz.css";
        htmllnkcss.Attributes.Add("rel", "stylesheet");
        htmllnkcss.Attributes.Add("type", "text/css");       
        hdflight.Controls.Add(htmllnkcss);


and for javascript...



HtmlGenericControl javascript = new HtmlGenericControl("script");
        javascript.Attributes["src"] = "HttpCombiner.ashx?fileName=js/jquery-1.3.2.min.js,js/blockui.js";
        javascript.Attributes["type"] = "text/javascript";
        hdflight.Controls.Add(javascript);


and now run your page and enjoy.....

Microsoft Ajax tool kit Problem Solved.

I have solved the problem associated with Microsoft Ajax tool kit script manager property "CombineScript = true".


Add the following code into web.config file.
<httpHandlers>
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
</httpHandlers>


and make a handler named CombineScriptsHandler.ashx


add the toolkit script manager like..


<cc1:ToolkitScriptManager ID="toolkitScriptMgr" EnablePartialRendering="false" CombineScripts="true" CombineScriptsHandlerUrl="~/CombineScriptsHandler.ashx" ScriptMode="Release" runat="server"  LoadScriptsBeforeUI="false">


and enjoy...

Microsoft Ajax tool kit Problem

I have used Microsoft Ajax tool kit controls like auto extender, extender calender and flyout in my project.


For using ajax functionality i have used ASP.NET Script Manager but while using Script manager .NET Framework generate script resource file of size 255 kb on client side for ajax functionality.


I have solved this problem by using toolkitScriptManager that inherit ASP.NET Script Manager and its reduced around 300 kb of script resource file but while i m using property CombineScripts = "true" .NET Framework combine script into one script resource file and compress it also but a java script error occured that "AjaxControlToolkit" is undefined in IE7.


any one have any better solution to minimize Script Resource file.

Trigger is not working with bulk update??

I have written a trigger like below...
-------------------------------------------------------------------------------------------------

IF UPDATE (GROUPCODE)
BEGIN
DECLARE @GROUPCODE_OLD VARCHAR(100),
@GROUPCODE_NEW VARCHAR(100)


SELECT @GROUPCODE_OLD = GROUPCODE FROM DELETED
SELECT @GROUPCODE_NEW = GROUPCODE FROM INSERTED
IF @GROUPCODE_OLD = @GROUPCODE_NEW
BEGIN
RETURN
END
ELSE
BEGIN


  SELECT  @GRADECODE=GRADECODE,       
  @COMPANYID = COMPANYID,      
  @COMPANYTYPECODE=COMPANYTYPECODE ,       
  @USER_CODE = LAST_UPD_BY,        
  @MASTERCODE = MASTERCODE
  FROM  INSERTED


  SELECT  @MASTER_COMPANYTYPECODE = COMPANYTYPECODE      
  FROM  TBL_COMPANY_MAS (NOLOCK)       
  WHERE  COMPANYID =@MASTERCODE 


  UPDATE TBL_COMMISSION_MAS SET ACTIVE=0 WHERE  COMPANYID=@COMPANYID

  SELECT  SERVICECODE AS SERVICE_CODE ,TMPL_ID    
  INTO  #TMP_DATA_GROUP  
  FROM  TBL_COMMISSION_TMPL_MAS WHERE 1=2  
        
  INSERT INTO #TMP_DATA_GROUP       
  SELECT  DISTINCT SERVICECODE as SERVICE_CODE ,TMPL_ID       
  FROM  TBL_COMMISSION_TMPL_MAS A (NOLOCK)      
  WHERE  CREATED_BY_COMPANY =@MASTERCODE      
  AND  CONVERT(NVARCHAR(10),FROM_DATE,111) <= 
(
SELECT MAX(CONVERT(NVARCHAR(10),FROM_DATE,111))       
FROM  TBL_COMMISSION_TMPL_MAS (NOLOCK)      
WHERE  CREATED_BY_COMPANY = @MASTERCODE      
AND SERVICECODE = A.SERVICECODE      
and CONVERT(NVARCHAR(10),FROM_DATE,111)<=CONVERT(NVARCHAR(10),GETDATE(),111)      
and GRADE_CODE =@GRADECODE
AND GROUPCODE = @GROUPCODE_NEW       
)        
  AND GRADE_CODE=@GRADECODE
  AND GROUPCODE = @GROUPCODE_NEW    
  AND ACTIVE =1          
     
  UNION      
     
  SELECT DISTINCT SERVICECODE as SERVICE_CODE ,TMPL_ID       
  FROM TBL_COMMISSION_TMPL_MAS A (NOLOCK)      
  WHERE  CREATED_BY_COMPANY =@MASTERCODE      
  AND CONVERT(NVARCHAR(10),FROM_DATE,111) > CONVERT(NVARCHAR(10),GETDATE(),111)               
  AND GRADE_CODE=@GRADECODE
  AND GROUPCODE = @GROUPCODE_NEW   
  AND ACTIVE =1    
          
--   DECLARE @TMPL_ID   VARCHAR(50)      
--   DECLARE @SERVICE_CODE VARCHAR(3)      
--   DECLARE @MSG_OUT int      
       
  WHILE EXISTS (SELECT TOP 1 '1' FROM  #TMP_DATA_GROUP)      
BEGIN      
SELECT @TMPL_ID = TMPL_ID FROM #TMP_DATA_GROUP ORDER BY TMPL_ID      
    
EXEC USP_SET_MARKUP_COMMISSION_WL @MASTERCODE, @MASTER_COMPANYTYPECODE,@TMPL_ID, @USER_CODE ,@MSG_OUT out,@COMPANYID,@GROUPCODE_NEW          
IF @@ERROR <> 0      
BEGIN      
ROLLBACK TRAN      
RETURN      
END      
    
DELETE  FROM #TMP_DATA_GROUP WHERE TMPL_ID= @TMPL_ID       
END 
END
END
-------------------------------------------------------------------------------------------------
but when i update this column either by query or by front end on by one it works fine, but when i write update query in bulk then its not working.

Any suggestion???