DataGrid中的按钮反选事件与NamingContainer(命名容器)-downmoon

王朝other·作者佚名  2006-12-26
窄屏简体版  字體: |||超大  

DataGrid中想实现这样的效果:

根据某一字段列的值动态改变按钮的文本,比如:

点击按钮列,自动更新某列原为0的值为1,并将按钮列的文本改为“置0”,

再按下,自动更新某列原为1的值为0,并将按钮列的文本改为“置1”,

最终通过NamingContainer,实现! 方法如下 :

.lineBorderBlue1

{

BORDER-TOP: #999999 1px groove;

BORDER-BOTTOM: #999999 1px groove;

BORDER-LEFT: #999999 1px groove;

BORDER-RIGHT: #999999 1px groove;

background-color:#efefef;

}

<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False">

<Columns>

<asp:BoundColumn DataField="HonoreeID" HeaderText="ID"></asp:BoundColumn>

<asp:BoundColumn DataField="status" HeaderText="状态">

<HeaderStyle Width="300px"></HeaderStyle>

</asp:BoundColumn>

<asp:TemplateColumn HeaderText="状态是否为0">

<HeaderStyle HorizontalAlign="Center" Width="10%"></HeaderStyle>

<ItemStyle HorizontalAlign="Center"></ItemStyle>

<ItemTemplate>

<asp:Label id="lb" runat="server" Visible="false" Text='<%# ((DataBinder.Eval(Container, "DataItem.status", "{0}"))=="0")?"是":"<font color=red>否</font>" %>'>

</asp:Label>

<asp:Button ID="changeState" Runat="server" Text='<%# ((DataBinder.Eval(Container, "DataItem.status", "{0}"))=="0")?"转为1":"转为0" %>'>

</asp:Button>

</ItemTemplate>

</asp:TemplateColumn>

</Columns>

</asp:DataGrid>

后台:

.lineBorderBlue1

{

BORDER-TOP: #999999 1px groove;

BORDER-BOTTOM: #999999 1px groove;

BORDER-LEFT: #999999 1px groove;

BORDER-RIGHT: #999999 1px groove;

background-color:#efefef;

}

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

public int KeyID

...{

get

...{

object o =ViewState ["KeyID"];

if(o!=null)

...{

return int.Parse(ViewState ["KeyID"].ToString());

}

else

...{

return 0;

}

}

set

...{

ViewState ["KeyID"] = value;

}

}

public int RowState

...{

get

...{ return int.Parse(ViewState ["RowState"].ToString());

}

set

...{

ViewState ["RowState"] = value;

}

}

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

...{

if(IsPostBack)

...{return ;

}

getData();

}

private void getData()

...{

//SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["DsnPubs"]);

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Mblog"]);

SqlCommand cmd;

con.Open();

cmd = new SqlCommand("select * from dbo.Honoree", con);

DataGrid1.DataSource = cmd.ExecuteReader();

DataGrid1.DataBind();

con.Close();

}

private bool UpdateData(int ID,int OldState)

...{

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Mblog"]);

SqlCommand cmd;

con.Open();

try

...{

string strSql="Update Honoree set Status={0} where HonoreeID={1}";

strSql=string.Format(strSql,(OldState==0?1:0).ToString(),ID.ToString());

cmd = new SqlCommand(strSql, con);

cmd.ExecuteNonQuery();

cmd.Dispose();

return true;

}

catch

...{

return false;

}

finally

...{

con.Close();

con.Dispose();

}

return false;

}

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

override protected void OnInit(EventArgs e)

...{

//

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

//

InitializeComponent();

base.OnInit(e);

}

/**//// <summary>

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

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

...{

this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);

this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);

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

}

#endregion

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

...{

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

...{

Button b=(Button)e.Item.FindControl("changeState");

if(b!=null)

...{

b.Click+=new EventHandler(b_Click);

}

}

}

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

...{

}

private void b_Click(object sender, EventArgs e)

...{

Button but = (Button)sender;

DataGrid dg = (DataGrid)but.NamingContainer.NamingContainer;

//此处是关键!!即找到包含按钮的命名容器的上层命名容器

if(dg == null) return;

DataGridItem di =(DataGridItem)but.NamingContainer;

TableCell key= (TableCell)di.Cells[0];

TableCell state= (TableCell)di.Cells[1];

KeyID=(key==null)?0:int.Parse(key.Text);

RowState=(state==null)?0:int.Parse(state.Text);

Response.Write(UpdateData(this.KeyID,this.RowState).ToString());

getData();

}

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航