Create DOM elements from client side

function makeNewNote(){

        mainDivElement = document.getElementById("mainDiv");

 

        newNote = document.createElement("div");

        newNote.setAttribute("id", "note"+getCurrentNumber());

 

        mainDivElement.appendChild(newNote);

 

        incrementCurrent();

 

      }

 

 

Reference : http://www.ibm.com/developerworks/web/library/wa-jsdom/

 

Get database object modified/created on filtered

--Following script will provide name of all the stored procedure which

--were modified in last 7 days.

 

SELECT name

FROM sys.objects

WHERE type = 'P'

AND DATEDIFF(D,modify_date, GETDATE()) < 2

----Change 7 to any other day value

 

--Following script will provide name of all the stored procedure which

--were created in last 7 days, they may or may not be modified after that.

 

SELECT name

FROM sys.objects

WHERE type = 'P'

AND DATEDIFF(D,create_date, GETDATE()) < 2

----Change 7 to any other day value.

 

--Other type options

--U for user table

--PK for primary key constraint

--F for foriegn key constraint

--P for sql stored procedure

 

 

Reference : http://blog.sqlauthority.com/2007/07/10/sql-server-2005-list-all-stored-procedure-modified-in-last-n-days/

 

SQL Get Table Column Names as output

SELECT

   ORDINAL_POSITION

  ,COLUMN_NAME

  ,DATA_TYPE

  ,CHARACTER_MAXIMUM_LENGTH

  ,IS_NULLABLE

  ,COLUMN_DEFAULT

FROM  

  INFORMATION_SCHEMA.COLUMNS

WHERE  

  TABLE_NAME = '<table_name>'

ORDER BY

  ORDINAL_POSITION ASC;

 

ASP.NET GridView/Table , set immovable/fixed header,footer and pager via CSS

CSS :

 

.FreezingHeader

{

   position:relative ;

   top:expression(this.offsetParent.scrollTop -12);

   z-index: 10;

}

.FreezingFooter

{

   position: relative;

   overflow-x: hidden;

   top: expression(parentNode.parentNode.offsetHeight >= offsetParent.offsetHeight ? 0 - parentNode.parentNode.offsetHeight + offsetParent.offsetHeight + offsetParent.scrollTop - 25 : 0);

}

.FreezingPager

{

   position: relative;

   overflow-x: hidden;

   top: expression(parentNode.parentNode.offsetHeight >= offsetParent.offsetHeight ? 0 - parentNode.parentNode.offsetHeight + offsetParent.offsetHeight + offsetParent.scrollTop - 25 : 0);

}

 

 

GRID MARKUP :

 

<div style="height:550px;overflow: scroll;width: 100%;position: relative;">

<asp:GridView ID="gridCounterparties" runat="server" AutoGenerateColumns="False"

                        AllowSorting="True" Width="100%" AllowPaging="True" ShowFooter="true"

                        onpageindexchanged="grid_PageIndexChanged"

                        onpageindexchanging="grid_PageIndexChanging"

                        onrowcommand="grid_RowCommand"

                        onrowcreated="grid_RowCreated"

                        onrowdatabound="grid_RowDataBound"

                        onsorting="grid_Sorting">

                        <PagerSettings Mode="Numeric" Visible="true" PageButtonCount="10" Position="Bottom" />

                        <PagerStyle CssClass="FreezingPager" BackColor="Aqua" />

                        <FooterStyle CssClass="FreezingFooter" BackColor="Aqua" />

                        <HeaderStyle CssClass="FreezingHeader" ForeColor="White"/>

 

                        <Columns>…

 

With the above CSS style, there are issues if your grid page has number of records overflow the height, but has less then grid page size. Meaning if alphabetical paging footer appear but not numerical paging. To fix the issue alphabetical paging footer should change the top value based on if the numerical paging is precent.

.FreezingFooter
{
position: relative;
overflow-x: hidden;
top: expression(parentNode.parentNode.offsetHeight >= offsetParent.offsetHeight ? 0 - parentNode.parentNode.offsetHeight + offsetParent.offsetHeight + offsetParent.scrollTop + (this.nextSibling ? -5 : -10) : 0);
}
.FreezingPager
{
position: relative;
overflow-x: hidden;
top: expression(parentNode.parentNode.offsetHeight >= offsetParent.offsetHeight ? 0 - parentNode.parentNode.offsetHeight + offsetParent.offsetHeight + offsetParent.scrollTop - 5 : 0);
}

Reference http://home.roadrunner.com/~bmerkey/examples/nonscroll-table-header.html