所属类别：.NET

文章作者：佚名

特别推荐：免费发布信息 承包关键词~~抢爆了！^HOT!

以前在asp很难实现代码重用,asp.net很好的解决了这个问题,以下是我写的DataGrid,继承DataGrid,加进了升降序/全并单元格/自动求和功能,原理很简单,但很好的实现的代码重用.using System;using System.Web.UI;using System.Web.UI.WebControls;using System.ComponentModel;using System.Data;using System.Data.SqlClient;namespace SunService{/// /// Summary description for DataGrid./// [DefaultProperty("Text"),ToolboxData("<{0}:DataGrid runat=server></{0}:DataGrid>")]public class DataGrid : System.Web.UI.WebControls.DataGrid{private string text;private SqlDataAdapter adp;private DataSet ds;private DataView view;private string[] arritem;[Bindable(true),Category("Appearance"),DefaultValue("")]public string Text{get{return text;}set{text = value;}}/// /// protect SortDirection 排序方向/// public string SortDirection{get{if(ViewState["SortDirection"]==null){return null;}else{if(ViewState["SortDirection"].ToString()==""){return null;}else{return ViewState["SortDirection"].ToString();}}}set{ViewState["SortDirection"]=value;}}/// /// protect SortField 排序字段/// public string SortField{get{if(ViewState["SortField"]==null){return null;}else{if(ViewState["SortField"].ToString()==""){return null;}else{return ViewState["SortField"].ToString();}}}set{ViewState["SortField"]=value;}}/// /// sql查询字串/// public string selectCommandText{get{if(ViewState["selectCommandText"]==null){return null;}else{if(ViewState["selectCommandText"].ToString()==""){return null;}else{return ViewState["selectCommandText"].ToString();}}}set{ViewState["selectCommandText"]=value;}}/// /// 连接字串/// public string selectConnectionString{get{if(ViewState["selectConnectionString"]==null){return null;}else{return ViewState["selectConnectionString"].ToString();}}set{ViewState["selectConnectionString"]=value;}}public DataTable Bindtable;public DataGrid(){this.Init+=new System.EventHandler(this.DataGrid_Init);}private void DataGrid_Init(object sender,EventArgs e){this.Load+= new System.EventHandler(this.DataGrid_Load);this.SortCommand+=new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid_SortCommand);this.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid_ItemDataBound);}private void DataGrid_Load(object sender,EventArgs e){this.HorizontalAlign=HorizontalAlign.Center;this.AllowSorting=true;arritem=new string[256];ds=new DataSet();}/// /// GRID绑定/// /// 查询字串/// 连接字串public void BindGrid(string selectCommandText,string selectConnectionString){this.selectCommandText=selectCommandText;this.selectConnectionString=selectConnectionString;BindGrid();}/// /// grid绑定/// /// 查询字串/// 连接对象public void BindGrid(string selectCommandText,SqlConnection cn){this.selectCommandText=selectCommandText;this.selectConnectionString=cn.ConnectionString;BindGrid();}/// /// grid绑定,必须先设置 selectCommmandText 及SelectConnectionString 属性/// public void BindGrid(){if(this.selectCommandText!=null&&this.selectConnectionString!=null){adp=new SqlDataAdapter(this.selectCommandText,this.selectConnectionString);adp.Fill(ds,"temp");view=ds.Tables["temp"].DefaultView;if(this.SortField!=null){view.Sort=this.SortField+" "+this.SortDirection;int sortfieldindex=0;for( inti=0;i<ds.Tables["temp"].Columns.Count;i++){if(ds.Tables["temp"].Columns[i].ColumnName==this.SortField){sortfieldindex=i;break;}}string SortDirectionImg="▲";if(this.SortDirection==" DESC"){SortDirectionImg="";}if(this.SortField!=this.DataKeyField){ds.Tables["temp"].Columns[sortfieldindex].ColumnName+=SortDirectionImg;}}Bindtable=ds.Tables["temp"];DataRow row=Bindtable.NewRow();row[0]="总计:";for(int i=1;i<Bindtable.Columns.Count;i++){Type t=Bindtable.Columns[i].DataType;if(t==typeof(Decimal)t==typeof(Double)t==typeof(Int16)t==typeof(Int32)t==typeof(Int64)t==typeof(UInt16)t==typeof(UInt32)t==typeof(Int64)){row[i]=0;foreach( DataRow r in Bindtable.Rows){try{row[i]=double.Parse(row[i].ToString())+double.Parse(r[i].ToString());}catch(Exception et){}}}}Bindtable.Rows.Add(row);this.DataSource=view;this.DataBind();}else{}}private void DataGrid_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e){if(this.SortDirection==" DESC"){this.SortDirection=" ASC";}else{this.SortDirection=" DESC";}this.SortField=e.SortExpression;this.SortField=this.SortField.Replace("▲","");this.SortField=this.SortField.Replace("","");BindGrid();}private void DataGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e){try{string txt="";for(int i=0;i<e.Item.Cells.Count;i++){//e.Item.Cells[i].Wrap=false;txt=e.Item.Cells[i].Text.Trim();if(myClass.IsDouble(txt)){e.Item.Cells[i].HorizontalAlign=HorizontalAlign.Right;}else{if(txt==arritem[i]&&txt!=""&&txt!=null){e.Item.Cells[i].Text="";}else{arritem[i]=txt;}}}}catch(Exception et){}}}}调用简单:把组件拖到页面中 ,假设ID为 DataGrid1:调用:DataGrid1.BindGrid(string selectCommandText,string selectConnectionString)这样省了建 conntion DataAdapter DataSet再绑定的时间.大家还可把显示时间显示格式/数字显示格式等加进ItemDataBound事件中,还有自定义分页功能等.关闭本页

....