给DataGrid添加滚动条并固定表头

1.html

<HTML>

<HEAD>

<title>ScrollGrid</title>

<style>

.fixedHeaderTr { POSITION: relative; ; TOP: expression(this.offsetParent.scrollTop) }

.mainDiv { SCROLLBAR-FACE-COLOR: #9999ff; OVERFLOW: auto; ; WIDTH: expression(document.body.clientWidth-20); ; HEIGHT: expression((document.body.clientHeight-this.offsetTop-20>this.children[0].offsetHeight)?(this.children[0].offsetHeight+20) : (document.body.clientHeight-this.offsetTop-20)) }

</style>

</HEAD>

<asp:DataGrid id="DataGrid1" runat="server" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px"

BackColor="White" CellPadding="4">

</asp:DataGrid>

</div>

</form>

</BODY>

</HTML>

2.cs 代码

public class ScrollGrid : System.Web.UI.Page

{

//记得要引用

//using System.Data.SqlClient;

//using System.IO;

//using System.Text.RegularExpressions;

protected System.Web.UI.WebControls.DataGrid DataGrid1;

private void Page_Load(object sender, System.EventArgs e)

{

DataBind();

}

#region Render

protected override void Render(HtmlTextWriter writer)

{

//原理就是把表头<tr></tr>标签替换为<tr class="fixedHeaderTr"></tr>

TextWriter tempWriter = new StringWriter();

base.Render(new HtmlTextWriter(tempWriter));

string oldtr = "<tr style=\"color:#FFFFCC;background-color:#990000;font-weight:bold;\">";

string newtr = "<tr class=\"fixedHeaderTr\" style=\"color:#FFFFCC;background-color:#990000;font-weight:bold;\">";

writer.Write(Regex.Replace(tempWriter.ToString(),oldtr,newtr,RegexOptions.IgnoreCase));

}

#endregion

#region DataBind

private void DataBind()

{

string sql="select * from testgrid";

DataSet ds=GetDataSet(sql);

this.DataGrid1.DataSource=ds;

this.DataGrid1.DataBind();

}

#endregion

#region GetDataSet

private DataSet GetDataSet(string sql)

{

string constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];

SqlDataAdapter sda =new SqlDataAdapter(sql,constring);

DataSet ds=new DataSet();

sda.Fill(ds);

return ds;

}

#endregion

Web Form Designer generated code

}

3.源代码下载/Files/singlepine/WebApplication1.rar
代码里面的数据库及web.config要自己修改。

posted on 2005-12-06 14:53 zacard 阅读(932) 评论(0) 收藏举报