We help IT Professionals succeed at work.

ASP.Net Datagrid - Scrolls and Sorts on Headers - Can I fix the Header as Well?

JB4375
JB4375 asked
on
272 Views
Last Modified: 2012-06-22
The title pretty much says it all. I just want the headers to stay put while I'm scrolling through the data. The existing code is below.

Thanks!!
<div style= "height:300px; overflow:auto;">           	     
	        <asp:GridView ID="GridView1" DataSourceID="SqlDataSource1" runat="server" DataKeyNames="Sequence"
            ForeColor="Black" ShowFooter="True" CellPadding="5"                  
            BackColor="White" BorderWidth="1px" BorderStyle="None" BorderColor="#CCCCCC" 
                 Height="135px" AllowSorting="True" AutoGenerateColumns="False">
                <Columns>
                    <asp:BoundField DataField="Dept" HeaderText="Department" ReadOnly="True"
                        SortExpression="Dept" />
                    <asp:BoundField DataField="DeptNum" HeaderText="Dept #" SortExpression="DeptNum" />
                    <asp:BoundField DataField="ZoneMgr" HeaderText="Zone Mgr" ReadOnly="True"
                        SortExpression="ZoneMgr" />
                    <asp:BoundField DataField="Phone" HeaderText="Phone" ReadOnly="True" 
                        SortExpression="Phone" />
                    <asp:BoundField DataField="Email" HeaderText="Email" ReadOnly="True" 
                        SortExpression="Email" />
                    <asp:BoundField DataField="BackupZM" HeaderText="Backup Zone Mgr" ReadOnly="True" 
                        SortExpression="BackupZM" />
                    <asp:BoundField DataField="BackupPhone" HeaderText="Backup Phone" ReadOnly="True" 
                        SortExpression="Backup Phone" />
                    <asp:BoundField DataField="BackupEmail" HeaderText="Backup Email" ReadOnly="True" SortExpression="BackupEmail" />
                 </Columns>
            <HeaderStyle Font-Bold="true" Wrap="false" ForeColor="White" BackColor="#333333" /> 
            <FooterStyle Font-Bold="true" Wrap="false" ForeColor="White" BackColor="#333333" />                
            <AlternatingRowStyle Font-Bold="True" Wrap="False" ForeColor="black" BackColor="#CCCC99"></AlternatingRowStyle>
            </asp:GridView>
   </div> <!-- end gridview-container -->             
	        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
	            SelectCommand="SELECT * FROM [ZMDeptsList]"
                ConnectionString="<%$ ConnectionStrings:MyConnection %>"                  
                DataSourceMode="DataSet">
             </asp:SqlDataSource>

Open in new window

Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks. I'd seen some of these but I think the code project article might do the trick.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.