控制DataGrid可编辑行且点击回车执行修改.
标题:控制可编辑行且点击回车执行修改.
声明:本帖只是一个测试Demo,所以,不会写得太规范,也不会考虑到安全性.以方便为 主.所以,用得到的朋友在项目中使用的时候,还希望对其进行改进.
环境
数据库访问类: SqlHelper.cs点击下载
开发工具: VS.net 2003
数据库: Sql Server 2000
作者:文刀无尽
日期: 2006-02-08
<%@ Page language="c#" Codebehind="RowEditLimit.aspx.cs" AutoEventWireup="false" Inherits="DataGridTest.RowEditLimit" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ><HTML> <HEAD> <title>RowEditLimit</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"> <script language="javascript">
function ReceiveKey()
{ if(event.keyCode==13) document.all.Label1.click();
}
</script> </HEAD> <body MS_POSITIONING="GridLayout" onkeydown="ReceiveKey()"> <form id="Form1" method="post" runat="server"> <FONT face="宋体"> <asp:datagrid id="dg" style="Z-INDEX: 101; LEFT: 96px; POSITION: absolute; TOP: 104px" runat="server" Height="208px" Width="304px" AutoGenerateColumns="False"> <Columns> <asp:BoundColumn DataField="ID" HeaderText="ID" ReadOnly="True"></asp:BoundColumn> <asp:BoundColumn DataField="Content" HeaderText="Content" ReadOnly="True"></asp:BoundColumn> <asp:BoundColumn DataField="Amount" HeaderText="Amount"></asp:BoundColumn> <asp:BoundColumn DataField="Total" HeaderText="Total"></asp:BoundColumn> <asp:ButtonColumn Visible="False" Text="edit" CommandName="edit"></asp:ButtonColumn> <asp:ButtonColumn Visible="False" Text="update" CommandName="update"></asp:ButtonColumn> </Columns> </asp:datagrid><asp:label id="Label1" style="Z-INDEX: 102; LEFT: 440px; POSITION: absolute; TOP: 72px" runat="server" Height="32px" Width="40px">保存</asp:label></FONT></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 Skyendless.DataAccess;namespace DataGridTest{ /// <summary> /// RowEditLimit 的摘要说明。 /// </summary> public class RowEditLimit : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid dg; protected System.Web.UI.WebControls.Label Label1; string connectionString = string.Empty; private void Page_Load(object sender, System.EventArgs e) { // //具体连接字符串,据自身情况而定 // connectionString = "Server = (local);uid = sa;pwd = sa;DataBase = test"; // 在此处放置用户代码以初始化页面 if(!Page.IsPostBack) { CreateDB(); DGBind(); } } /// <summary> /// 创建数据库 /// </summary> private void CreateDB() { string createDB = @" if not exists(select 1 from sysobjects where name = 'test' and xtype = 'u') Begin Create table Test(ID int ,Content varchar(20) ,Amount int ,Total int ) insert into test select 1,'可修改',100,200 union select 2,'固定',200,200 End "; try { SqlHelper.ExecuteNonQuery(connectionString,CommandType.Text,createDB); } catch(Exception ex) { this.Label1.Text = ex.Message.ToString(); } } /// <summary> /// 绑定数据 /// </summary> private void DGBind() { DataSet ds = new DataSet(); try { // //具体路径根据自己的情况进行修改 // string cmdText = "select * from test"; ds = SqlHelper.ExecuteDataset(connectionString,CommandType.Text,cmdText); dg.DataSource = ds.Tables[0].DefaultView; dg.DataBind(); } catch(Exception ex) { this.Label1.Text = ex.Message.ToString (); } }
Web 窗体设计器生成的代码 private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem) { if(e.Item.Cells[1].Text == "可修改") { e.Item.Attributes.Add("ondblclick","__doPostBack('"+((LinkButton)e.Item.Cells[4].Controls[0]).ClientID.Replace("__","$_")+"','')"); } } if(e.Item.ItemType==ListItemType.EditItem) { this.Label1.Attributes.Add("onclick","__doPostBack('"+((LinkButton)e.Item.Cells[5].Controls[0]).ClientID.Replace("__","$_")+"','')"); ((TextBox)e.Item.Cells[2].Controls[0]).Attributes.Add("onmouseover","this.select()"); ((TextBox)e.Item.Cells[3].Controls[0]).Attributes.Add("onmouseover","this.select()"); } } private void dg_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if(e.CommandName=="edit") { this.dg.EditItemIndex=e.Item.ItemIndex; } if(e.CommandName=="update") { try { string cmdText = string.Format("Update test set Amount = {0} ,total = {1} where ID = {2}" ,((TextBox)e.Item.Cells[2].Controls[0]).Text ,((TextBox)e.Item.Cells[3].Controls[0]).Text ,e.Item.Cells[0].Text); SqlHelper.ExecuteNonQuery(connectionString,CommandType.Text,cmdText); } catch (Exception ex) { this.Label1.Text = ex.Message.ToString(); } finally { this.dg.EditItemIndex=-1; } } DGBind(); } private void Button1_Click(object sender, System.EventArgs e) { } }}
