Friday 18 November 2011

Scrollable Gridview with fixed headers in asp.net

Related Queries:-
horizontal and vertical scrollable Gridview with static header row. 

fixed header in gridview in asp.net.

static header in gridview through java script.


I was looking for a solution for this for a long time and found most of the answers are not working or not suitable for my situation i also find most of the java script code for that they worked but only with the vertical scroll not with the horizontal scroll and also combination of header and rows doesn't match.

I wrote this article for the best solution and i tested it at all browser IE 7,IE  8 with compatibility and normal mode,Firefox,Opera etc.

Steps include:-
  • Copying Gridview into divHeaderRow show only header,hide all rows and applying style to it so that divHeaderRow placed onto the top of the Gridview header row.
  • If isFooter is true then Copying Gridview Footer row into divFooterRow and applying style to divFooterRow.
 
Copy and paste given bellow javascript code inside the <head> tag.
JavaScript code:-  

<script language="javascript" type="text/javascript">

function MakeStaticHeader(gridId, height, width, headerHeight, isFooter) {
var tbl = document.getElementById(gridId);
if (tbl) {
var DivHR = document.getElementById('DivHeaderRow');
var DivMC = document.getElementById('DivMainContent');
var DivFR = document.getElementById('DivFooterRow');
//*** Set divheaderRow Properties ****
DivHR.style.height = headerHeight + 'px';
DivHR.style.width = (parseInt(width) - 16) + 'px';
DivHR.style.position = 'relative';
DivHR.style.top = '0px';
DivHR.style.zIndex = '10';
DivHR.style.verticalAlign = 'top';
//*** Set divMainContent Properties ****
DivMC.style.width = width + 'px';
DivMC.style.height = height + 'px';
DivMC.style.position = 'relative';
DivMC.style.top = -headerHeight + 'px';
DivMC.style.zIndex = '1';
//*** Set divFooterRow Properties ****
DivFR.style.width = (parseInt(width) - 16) + 'px';
DivFR.style.position = 'relative';
DivFR.style.top = -headerHeight + 'px';
DivFR.style.verticalAlign = 'top';
DivFR.style.paddingtop = '2px';
if (isFooter) {
var tblfr = tbl.cloneNode(true);
tblfr.removeChild(tblfr.getElementsByTagName('tbody')[0]);
var tblBody = document.createElement('tbody');
tblfr.style.width = '100%';
tblfr.cellSpacing = "0";
//*****In the case of Footer Row *******
tblBody.appendChild(tbl.rows[tbl.rows.length - 1]);
tblfr.appendChild(tblBody);
DivFR.appendChild(tblfr);
}
//****Copy Header in divHeaderRow****
DivHR.appendChild(tbl.cloneNode(true));
}
}
function OnScrollDiv(Scrollablediv) {
document.getElementById('DivHeaderRow').scrollLeft = Scrollablediv.scrollLeft;
document.getElementById('DivFooterRow').scrollLeft = Scrollablediv.scrollLeft;
}

</script>


Then Copy this code and paste and place your Grid View inside DivMainContent.
HTML Code:-

<div id="DivRoot" align="left">
    <div style="overflow: hidden;" id="DivHeaderRow">
    </div>

    <div style="overflow:scroll;" onscroll="OnScrollDiv(this)" id="DivMainContent">
       
      <%--  Place Your GridView Here
<asp:GridView  runat="server"  ID="gridshow" Width="100%" AutoGenerateColumns="False"ShowFooter="True">
         <Columns>
                //...................
         </Columns>
       </asp:GridView>
      --%>
      
    </div>

    <div id="DivFooterRow" style="overflow:hidden">
    </div>
</div>

Then Call function MakeStaticHeader in Aspx.CS File at the time of binding Gridview and pass the Some parameters
  1. ClientId of Gridview
  2. Height of Scrollable div
  3. Width of Scrollable div
  4. Height of Table Header Row
  5. IsFooter (true/false) If you want to Make footer static or not.

protected void btnBindGrid_Click(object sender, EventArgs e)
{
  //Fill Ds
  gridShow.DataSource = ds;
  gridShow.DataBind();

  ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "MakeStaticHeader('" + gridShow.ClientID + "', 400, 950 , 55 ,true)", true);
}



No comments:

Post a Comment