HTML::
<%@ Page language="c#" Codebehind="DGSorting.aspx.cs" AutoEventWireup="false" Inherits="DataGridOperate.DGSorting" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>DGSorting</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:datagrid id="DataGrid1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"
DataKeyField="ID">
<Columns>
<asp:EditCommandColumn ButtonType="PushButton" UpdateText="更新" HeaderText="操作" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>
<asp:BoundColumn DataField="ID" ReadOnly="True" HeaderText="编号"></asp:BoundColumn>
<asp:BoundColumn DataField="Name" SortExpression="Name" HeaderText="姓名"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="性别">
<ItemTemplate>
<asp:Label ID="lblSex" Runat="server" Text='<%# DataBinder.Eval(Container,"DataItem.Sex").ToString() %>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:CheckBox ID="chkSex" Runat="server"></asp:CheckBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="Tel" HeaderText="电话"></asp:BoundColumn>
<asp:TemplateColumn>
<HeaderTemplate>
<asp:Button id="btnSort" Text="薪资" Runat="server" CommandName="sort" CommandArgument="Salary"></asp:Button>
</HeaderTemplate>
<ItemTemplate>
<asp:Label id=lblSalary Text='<%# DataBinder.Eval(Container,"DataItem.Salary").ToString() %>' Runat="server">
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="部门">
<ItemTemplate>
<asp:Label ID="Label1" Runat="server" Text='<%# DataBinder.Eval(Container,"DataItem.Depart").ToString() %>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddlDepart" Runat="server"></asp:DropDownList>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle Mode="NumericPages"></PagerStyle>
</asp:datagrid></form>
</body>
</HTML>
后置代码:
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;
namespace DataGridOperate
{
/// <summary>
/// DGSorting 的摘要说明。
/// </summary>
public class DGSorting : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected DataSet dsEmployee = new DataSet();
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
this.Admin();
}
}
private void Admin()
{
SqlConnection Conn = new SqlConnection("server=.;database=test;uid=sa");
string strSQL = "select * from salary";
SqlDataAdapter adapter = new SqlDataAdapter(strSQL,Conn);
adapter.Fill(dsEmployee);
this.DataGrid1.DataSource = dsEmployee;
this.DataGrid1.DataBind();
this.ViewState["source"] = dsEmployee;
}
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex = -1;
this.Admin();
}
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.ViewState["Sex"] = ((Label)e.Item.Cells[3].FindControl("lblSex")).Text;
this.ViewState["Depart"] = ((Label)e.Item.Cells[3].FindControl("Label1")).Text;
this.DataGrid1.EditItemIndex = e.Item.ItemIndex;
this.Admin();
}
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection Conn = new SqlConnection("server=.;database=test;uid=sa");
string strSQL = "update salary set name=@name,sex=@sex,tel=@tel,salary=@salary,depart=@depart where id=@id";
SqlCommand Comm = new SqlCommand(strSQL,Conn);
Comm.Parameters.Add(new SqlParameter("@name",System.Data.SqlDbType.VarChar,16));
Comm.Parameters.Add(new SqlParameter("@sex",System.Data.SqlDbType.Bit,1));
Comm.Parameters.Add(new SqlParameter("@tel",System.Data.SqlDbType.VarChar,50));
Comm.Parameters.Add(new SqlParameter("@salary",System.Data.SqlDbType.Int,4));
Comm.Parameters.Add(new SqlParameter("@depart",System.Data.SqlDbType.VarChar,12));
Comm.Parameters.Add(new SqlParameter("@id",System.Data.SqlDbType.Int,4));
Comm.Parameters["@id"].Value = this.DataGrid1.DataKeys[e.Item.ItemIndex];
Comm.Parameters["@name"].Value = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
Comm.Parameters["@sex"].Value = ((CheckBox)e.Item.Cells[3].FindControl("chkSex")).Checked;
Comm.Parameters["@tel"].Value = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
Comm.Parameters["@salary"].Value = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
Comm.Parameters["@depart"].Value = ((DropDownList)e.Item.Cells[6].FindControl("ddlDepart")).SelectedItem.Text;
Comm.Connection.Open();
Comm.ExecuteNonQuery();
Comm.Connection.Close();
this.DataGrid1.EditItemIndex = -1;
this.Admin();
}
private DataView GetSource()
{
SqlConnection Conn = new SqlConnection("server=.;database=test;uid=sa");
string strSQL = "select * from depart";
SqlDataAdapter adapter = new SqlDataAdapter(strSQL,Conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
DataView dv = ds.Tables[0].DefaultView;
return dv;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand);
this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DataGrid1_SortCommand(object source, DataGridSortCommandEventArgs e)
{
DataView dv = ((DataSet)this.ViewState["source"]).Tables[0].DefaultView;
bool SortAscending = true;
if(this.ViewState["State"]==null)
{
SortAscending = true;
}
else
{
SortAscending = !bool.Parse(this.ViewState["State"].ToString());
}
if(SortAscending)
{
dv.Sort = e.SortExpression;
}
else
{
dv.Sort = e.SortExpression+" DESC";
}
this.ViewState["State"] = SortAscending;
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}
private void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.EditItem)
{
DropDownList ddl = (DropDownList)e.Item.FindControl("ddlDepart");
ddl.DataSource = this.GetSource();
ddl.DataTextField = "Depart";
ddl.DataBind();
ddl.SelectedValue = this.ViewState["Depart"].ToString();
((CheckBox)e.Item.Cells[3].FindControl("chkSex")).Checked = bool.Parse(this.ViewState["Sex"].ToString().Trim());
}
}
private void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
try
{
this.DataGrid1.CurrentPageIndex = e.NewPageIndex ;
}
catch
{
this.DataGrid1.CurrentPageIndex = 0;
}
this.Admin();
}
}
}
---------------------------------------------------------------------------------------------------------------------
可以不用ViewState保存下拉选框中的值
string str = ((DataSet)DataGrid1.DataSource).Tables[0].Rows[DataGrid1.EditItemIndex]["Depart"].ToString();
((DropDownList)(e.Item.FindControl("ddpDepart"))).Items.FindByText(str).Selected = true;