Scrollable Gridview with fixed headers in asp.net

 Scrollable Gridview with fixed headers in asp.net

Related Queries:-
horizontal and vertical scrollable Gridview with static headerrow. 
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 rowsand applying style to it so that divHeaderRow placed onto the top of the Gridview header row.
  • If isFooter is true thenCopying 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”;

 tblfr.border = “0px”;
  tblfr.rules = “none”;
 //*****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(Change GrdDisplay.ClientID as your gridview clientid)
  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”, “<script>MakeStaticHeader(‘” + GrdDisplay.ClientID + “‘, 400, 950 , 40 ,true); </script>”, false);
}
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s