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 Microsoft.ApplicationBlocks.Data;
namespace test { /// <summary> /// WebForm6 的摘要说明。 /// </summary> public class WebForm6 : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid DataGrid1; protected string conn=test.conn; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if(!IsPostBack) { bind(); } }
#region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 – 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand); this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand_1); 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 bind() { DataGrid1.DataSource=SqlHelper.ExecuteDataset(conn,CommandType.Text,”select c.c_name,a.a_id,a.a_name from article a,category c where a.c_id=c.c_id”); DataGrid1.DataBind(); }
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e) { }
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) {
if(e.Item.ItemType==ListItemType.EditItem) { DropDownList dl=(DropDownList)e.Item.FindControl(“ddl1”); dl.DataSource=SqlHelper.ExecuteDataset(conn,CommandType.Text,”select * from category”); dl.DataValueField=”c_id”; dl.DataTextField=”c_name”; dl.DataBind(); string str=Convert.ToString(DataBinder.Eval(e.Item, “DataItem.c_name”)); try { dl.Items.FindByText(str).Selected=true; } catch { } } }
private void DataGrid1_EditCommand_1(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { this.DataGrid1.EditItemIndex=e.Item.ItemIndex; bind(); }
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string uid=e.Item.UniqueID+”:”;//注意别遗漏冒号 string c_name=Request.Form[uid+”ddl1″].ToString(); string a_name=Request.Form[uid+”a_name”].ToString(); // string a_name=((TextBox)e.Item.Controls[2].Controls[0]).Text; int id=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; SqlHelper.ExecuteNonQuery(conn,CommandType.Text,”update article set c_id=”+c_name+”,a_name='”+a_name+”‘ where a_id=”+id); DataGrid1.EditItemIndex=-1; bind(); }
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGrid1.EditItemIndex=-1; bind(); } } }
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/182338.html原文链接:https://javaforall.cn