DataGrid部分功能实现[原创]-CSDN博客

我把我原来写的一个关于DataGrid的功能的程序公布出来，都是些使用的东西，希望能给.net的初学者一点点帮助……,写的不好的地方请大家多多指教！
——缘易(Hermes Liu)

//DataGrid_1.aspx
**************************************************************************

< body MS_POSITIONING ="GridLayout" >

< form id ="Form1" method ="post" runat ="server" >

< asp:datagrid id ="Dg1" style ="Z-INDEX: 101; LEFT: 7px; POSITION: absolute; TOP: 8px" runat ="server"

HeaderStyle-HorizontalAlign ="Center" HeaderStyle-Font-Bold ="True" HeaderStyle-BackColor ="#6699cc"

AutoGenerateColumns ="false" ItemStyle-HorizontalAlign ="Center" >

< Columns >

< asp:EditCommandColumn HeaderText ="编辑" EditText ="编辑" CancelText ="取消" UpdateText ="更新" ItemStyle-Width ="100" ></ asp:EditCommandColumn >

< asp:ButtonColumn HeaderText ="删除" ButtonType ="LinkButton" Text ="删除" CommandName ="Delete" ItemStyle-Width ="60" ></ asp:ButtonColumn >

< asp:BoundColumn ReadOnly ="True" HeaderText ="用户编号" DataField ="customerid" ></ asp:BoundColumn >

< asp:BoundColumn DataField ="companyname" HeaderText ="公司名" ></ asp:BoundColumn >

< asp:BoundColumn DataField ="contactname" HeaderText ="联系名" ></ asp:BoundColumn >

</ Columns >

</ asp:datagrid >

< asp:Label id ="Label1" style ="Z-INDEX: 102; LEFT: 14px; POSITION: absolute; TOP: 237px" runat ="server" > Label </ asp:Label ></ form >

</ body >

//DataGrid_1.aspx.cs
**************************************************************************

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Configuration;

using DBF_Center;

namespace TestCenter

{

/**//// <summary>

/// *******************************DataGrid全部功能实现****************************************

/// </summary>

public class DataGrid_1 : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Label Label1;

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

/**//// <summary>

/// 数据邦定函数

/// </summary>

/// <param name="sortField">用于排序的字段</param>

public void BindGrid(string sortField)

{

//连接数据库，填充DataSet

string constr=System.Configuration.ConfigurationSettings.AppSettings["Connectstring"];

SqlConnection conn=new SqlConnection(constr);

string commstr="select customerid,companyname,contactname from customer";

SqlDataAdapter ad=new SqlDataAdapter(commstr,conn);

DataSet dst=new DataSet();

ad.Fill(dst);

//string pd_a="select * from newstype order by t_id desc";

DataView source=new DataView(dst.Tables[0]);

source.Sort=sortField;

Dg1.DataSource=source;

Dg1.DataBind();

}

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

{

if(!IsPostBack)

{

this.BindGrid("customerid");//数据邦定，按customerid排序

}

Dg1.PagerStyle.Mode=PagerMode.NumericPages;//显示默认的页码为数字

/**//*

* 以上下页的形式显示页码

Dg1.PagerStyle.Mode=PagerMode.NextPrev;

Dg1.PagerStyle.NextPageText="下一页";

Dg1.PagerStyle.PrevPageText="上一页";

Dg1.PagerStyle.Position=0;//显示起始页码

Dg1.PagerStyle.PageButtonCount=10;//显示显示页数

Dg1.PagerStyle.Visible=true;//显示默认页码数

Dg1.PageSize=6;//每页显示信息数

Dg1.AllowPaging=true;

Dg1.AllowSorting=true;

Dg1.AutoGenerateColumns=false;

}

Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码

override protected void OnInit(EventArgs e)

{

// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

InitializeComponent();

base.OnInit(e);

}

/**//// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

this.Dg1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.ItemCreate_Grid);

this.Dg1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.Pager_Grid);

this.Dg1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Cancel_Grid);

this.Dg1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Edit_Grid);

this.Dg1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.Sort_Grid);

this.Dg1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Update_Grid);

this.Dg1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.Delete_Grid);

this.Dg1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.ItemBound_Grid);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

//实现自动排序

private void Sort_Grid(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)

{

this.BindGrid((string)e.SortExpression);

}

//编辑按钮的实现

private void Edit_Grid(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

Dg1.EditItemIndex=e.Item.ItemIndex;

this.BindGrid("customerid");

}

//取消按钮的实现

private void Cancel_Grid(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

Dg1.EditItemIndex=-1;

this.BindGrid("customerid");

}

//更新数据

private void Update_Grid(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

TextBox C_name=(TextBox)e.Item.Cells[3].Controls[0];

//TextBox C_nid=(TextBox)e.Item.Cells[2].Controls[0];

TextBox C_cname=(TextBox)e.Item.Cells[4].Controls[0];

string C_id=e.Item.Cells[2].Text.ToString();

if(C_name.Text.ToString()=="")

{

Response.Write("<script LANGUAGE='javascript'>alert('请输入确认输入正确!');history.go(-1);</script>");

}

else

{

string up_sql="update customer set Companyname='"+C_name.Text.ToString()+"',contactname='"+C_cname.Text.ToString()+"' where customerid='"+C_id+"'";

dbcontrol.ExecuteSql(up_sql);

Label1.Text=up_sql;

}

Dg1.EditItemIndex=-1;

this.BindGrid("customerid");

}

//自动分页

private void Pager_Grid(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)

{

Dg1.CurrentPageIndex=e.NewPageIndex;

BindGrid("customerid");

}

//Item事件

private void ItemCreate_Grid(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

{

if(e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem||e.Item.ItemType==ListItemType.Item)

{

LinkButton btnDel=(LinkButton)e.Item.Cells[1].Controls[0];

btnDel.Attributes.Add("onClick","JavaScript:return confirm('确认要删除此行的信息？')");

btnDel.Text="删除";

}

//执行删除

private void Delete_Grid(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

{

string del_sql="delete from customer where customerid='"+e.Item.Cells[2].Text+"'";

dbcontrol.ExecuteSql(del_sql);

Dg1.EditItemIndex=-1;

BindGrid("customerid");

}

//行随鼠标移动变色

private void ItemBound_Grid(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

{

if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

e.Item.Attributes.Add("onmouseover","this.style.backgroundColor='#fafafa'");

e.Item.Attributes.Add("onmouseout","this.style.backgroundColor='white'");

}

转载于:https://www.cnblogs.com/hermes262/archive/2006/03/03/342293.html