Simple Cursor Example in SQL

    DECLARE @Pram int

    DECLARE aCursor CURSOR
    FOR
        SELECT
            *

        FROM
            TableName

    OPEN aCursor


    FETCH NEXT FROM aCursor INTO
        @Pram

    WHILE @@FETCH_STATUS = 0
        BEGIN
            --'what you want to do hear'
            FETCH NEXT FROM aCursor INTO
                @Pram
        END
    CLOSE aCursor
    DEALLOCATE aCursor

Comments

Tata Punch: A Compact SUV That Packs a Punch

Postback Page using Javascript in ASP.net

Postback Page using Javascript in ASP.net For Calling Function: __doPostBack('__Page', ''); Function: function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() != false)) { theForm.__EVENTTARGET.value = eventTarget; theForm.__EVENTARGUMENT.value = eventArgument; theForm.submit(); } }

Custom calendar in asp.net

<form id="form1" runat="server"> <div> <asp:DropDownList ID="ddlMonth" runat="server" OnSelectedIndexChanged="ddlMonth_SelectedIndexChanged" AutoPostBack="true"> <asp:ListItem Text="Jan" Value="1"></asp:ListItem> <asp:ListItem Text="Feb" Value="2"></asp:ListItem> <asp:ListItem Text="Mar" Value="3"></asp:ListItem> <asp:ListItem Text="Apr" Value="4"></asp:ListItem> <asp:ListItem Text="May" Value="5"></asp:ListItem> ...

ASP.Net

Search This Blog