Mar 30, 2013

Get Next Number with REPLICATE In SQL Server

Get Next max value for custom identification of table value


SELECT 'PR' + Substring( '2012-2013', 3, 2 )
       + Replicate('0', 4-Len(Count(*)+1))
       + Cast(Count(*)+1 AS VARCHAR(4)) AS NewCode
FROM   tablename
WHERE  pro_finyear = '2012-2013' 



OUTPUT
=================

NewCode 
PR120012

Mar 9, 2013

Jquery animation cutting Ribbon with scissors




<body>
    <form id="form1" runat="server">
        <img class="RibbonL" src="Images/LeftRibbon.png" />
        <img class="RibbonR" src="Images/RightRibbon.png" />
        <img id="imgFollow" style="position: relative;" class="imgFollow" width="145px" height="145px" src="Images/scissors.png" />
        <script src="jquery-1.6.2.min.js" type="text/javascript"></script>
        <script type="text/javascript">
            $(document).ready(function () {



                $(document).mousemove(function (e) {
                    $('#imgFollow').offset({
                        left: e.pageX + 30,
                        top: e.pageY - 20
                    });
                    $('#imgFollow').css('z-index', '1000');

                });

                $(".RibbonR, .RibbonL ").click(function () {
                    $(".RibbonL").hide(1000);
                    $(".RibbonR").hide(1000);

                    setTimeout(function () { //redirect after a certain time
                        $(window.location).attr('href', 'http://itapps.cgglobal.com/cgict/');
                    }, 1200);
                });

            });
        </script>
    </form>
</body>

Dec 7, 2012

How to fix Column of Gridview or scrollable grid in Asp.net


Jquery plugin js file for scrollable grid



=========================================================
1. ScrollableGridPlugin.js


(function ($) {
    $.fn.Scrollable = function (options) {
        var defaults = {
            ScrollHeight: 300,
            Width: 0
        };
        var options = $.extend(defaults, options);
        return this.each(function () {
            var grid = $(this).get(0);
            var gridWidth = grid.offsetWidth;
            var gridHeight = grid.offsetHeight;
            var headerCellWidths = new Array();
            for (var i = 0; i < grid.getElementsByTagName("TH").length; i++) {
                headerCellWidths[i] = grid.getElementsByTagName("TH")[i].offsetWidth;
            }
            grid.parentNode.appendChild(document.createElement("div"));
            var parentDiv = grid.parentNode;

            var table = document.createElement("table");
            for (i = 0; i < grid.attributes.length; i++) {
                if (grid.attributes[i].specified && grid.attributes[i].name != "id") {
                    table.setAttribute(grid.attributes[i].name, grid.attributes[i].value);
                }
            }
            table.style.cssText = grid.style.cssText;
            table.style.width = gridWidth + "px";
            table.appendChild(document.createElement("tbody"));
            table.getElementsByTagName("tbody")[0].appendChild(grid.getElementsByTagName("TR")[0]);
            var cells = table.getElementsByTagName("TH");

            var gridRow = grid.getElementsByTagName("TR")[0];
            for (var i = 0; i < cells.length; i++) {
                var width;
                if (headerCellWidths[i] > gridRow.getElementsByTagName("TD")[i].offsetWidth) {
                    width = headerCellWidths[i];
                }
                else {
                    width = gridRow.getElementsByTagName("TD")[i].offsetWidth;
                }
                cells[i].style.width = parseInt(width - 3) + "px";
                gridRow.getElementsByTagName("TD")[i].style.width = parseInt(width - 3) + "px";
            }
            parentDiv.removeChild(grid);

            var dummyHeader = document.createElement("div");
            dummyHeader.appendChild(table);
            parentDiv.appendChild(dummyHeader);
            if (options.Width > 0) {
                gridWidth = options.Width;
            }
            var scrollableDiv = document.createElement("div");
            if (parseInt(gridHeight) > options.ScrollHeight) {
                gridWidth = parseInt(gridWidth) + 17;
            }
            scrollableDiv.style.cssText = "overflow:auto;height:" + options.ScrollHeight + "px;width:" + gridWidth + "px";
            scrollableDiv.appendChild(grid);
            parentDiv.appendChild(scrollableDiv);
        });
    };
})(jQuery);


=========================================================
2. Default page with GridView

 <script src="../App_Themes/Theme1/ScrollableGridPlugin.js" type="text/javascript"></script>

 <script type="text/javascript" language="javascript">
    
     $(document).ready(function () {
        $('#<%=gridview1.ClientID %>').Scrollable({
            ScrollHeight: 300
        });
    });

</script>
=========================================================

Nov 26, 2012

My Login Page

I have create login page by altering in PSD file 


-------------------------------------

Nov 20, 2012

How To do Shopping CART In asp.net

There are some links i found on internet for shopping cart website.

http://www.codeproject.com/Articles/17674/GridView-Order-Page-Shopping-Cart-Page-ASP-NET-SQL

http://net.tutsplus.com/tutorials/other/build-a-shopping-cart-in-aspnet/

(free and open source shopping cart )
http://www.nopcommerce.com/default.aspx



( some helpfull code )
http://howtouseasp.net/how-to-do-shopping-cart-in-asp-net-c/

http://www.codeproject.com/Tips/403267/ShoppingCart-using-Gridview-in-ASP-NET

http://www.ajaxprojects.com/ajax/tutorialdetails.php?itemid=423

http://my.safaribooksonline.com/book/web-development/microsoft-aspdotnet/0957921861/building-an-aspdotnet-shopping-cart/aspnet-chp-12

( download ER-Diagrams of Ecommerce website )
http://www.uml-diagrams.org/examples/online-shopping-example.html

(Download Sample)
http://csharpdotnetfreak.blogspot.com/2009/05/aspnet-creating-shopping-cart-example.html

http://www.aboutmydot.net/web-development/shopping-cart-in-aspnet.html

( LIVE  DEMO )
http://www.dotnetcart.com/livedemo.htm

( Demo and Source code)
http://www.znode.com/asp-net-shopping-cart-source-code.aspx

(Sample and Source code)
http://www.codeproject.com/Articles/3765/Easy-ASP-NET-Shopping-Cart

(sample and source code )
http://www.c-sharpcorner.com/UploadFile/ShrutiShrivastava/ASPNetShoppingCart11262005063508AM/ASPNetShoppingCart.aspx


(Sample , source code and link )
http://www.c-sharpcorner.com/forums/thread/160928/developing-a-shopping-cart-in-asp-net.aspx

(download source sample )
http://www.aspfree.com/c/a/c-sharp/creating-an-online-shopping-cart-and-paypal-system/

(Nope commerce free open source)
http://www.nopcommerce.com/default.aspx

What is the use of n-tier architecture and 3-tier architecture?

how to implement 3-tier architecture in asp.net using c#. 3-Tier architecture is also called layered architecture. Some people called it ...