gridview 下拉DropDownList 更新操作

来源：互联网发布：nginx 不能通过ip访问编辑：程序博客网时间：2024/05/16 17:01

前台代码<html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <h1 style=" text-align:center" mce_style=" text-align:center">编辑Gridview</h1> <asp:GridView ID="grid" runat="server" AutoGenerateColumns="False" Width=100% Height=100% DataKeyNames="id" onrowcommand="grid_RowCommand" onrowcancelingedit="grid_RowCancelingEdit" onrowdatabound="grid_RowDataBound" onrowediting="grid_RowEditing" onrowupdating="grid_RowUpdating" > <Columns> <asp:TemplateField HeaderText="姓名" > <HeaderStyle HorizontalAlign=Left/> <ItemTemplate> <%#Eval("name") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="地址" > <HeaderStyle HorizontalAlign=Left/> <ItemTemplate> <%#Eval("address") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="年龄" > <HeaderStyle HorizontalAlign=Left/> <ItemTemplate> <%#Eval("age") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="国家" > <HeaderStyle HorizontalAlign=Left/> <ItemTemplate> <%#Eval("country_name") %> </ItemTemplate> <EditItemTemplate> <asp:HiddenField Value='<%#Eval("country_id") %>' ID="hdd_countryid" runat=server/> <asp:DropDownList ID="dd_country" runat=server></asp:DropDownList> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="测试"> <HeaderStyle HorizontalAlign=Left/> <ItemTemplate> <asp:LinkButton CommandArgument='<%#Eval("ID") %>' Text="测试" runat=server CommandName="test"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:CommandField ShowEditButton=true ShowCancelButton=true ShowDeleteButton=true HeaderText="编辑"/> </Columns> </asp:GridView> </form></body></html>

后台代码public partial class GridView_DropDownList : System.Web.UI.Page
{

    private DataAccess da = SingleTon<DataAccess>.Instance;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.Page.IsPostBack)
        {
            BindGridView();

        }
    }

    private void BindGridView()
    {
        DataTable dt = da.GetTable("select name,address,age,country_id,country_name ,id from userinfo ,country where country_id=country ");
        grid.DataSource = dt;
        grid.DataBind();
    }

    /// <summary>
    /// command命令操作gridview
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
    {


        if (e.CommandName == "test")
        {
          string id= e.CommandArgument.ToString();

          Response.Write(" <script> javascript:alert( '" + id + "'); </script> ");
          Response.Flush();
        }
    }

    private void BindDropDownListCountry(DropDownList drp)
    {
        DataTable dt = da.GetTable("select country_id,country_name from country");
        drp.DataSource = dt;
        drp.DataValueField="country_id";
        drp.DataTextField = "country_name";
        drp.DataBind();
    }
    protected void grid_RowEditing(object sender, GridViewEditEventArgs e)
    {
        grid.EditIndex = e.NewEditIndex;
        BindGridView();
    }
    protected void grid_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        grid.EditIndex = -1;
        BindGridView();
    }
    protected void grid_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow && ((e.Row.RowState & DataControlRowState.Edit) > 0))
        {
            DropDownList drp = e.Row.FindControl("dd_country") as DropDownList;
            BindDropDownListCountry(drp);
            drp.SelectedValue = (e.Row.FindControl("hdd_countryid") as HiddenField).Value ;
        }
    }

    /// <summary>
    /// 更新
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

        DropDownList drp = grid.Rows[e.RowIndex].FindControl("dd_country") as DropDownList;
        string country_ID=drp.SelectedValue;
        string id = grid.DataKeys[e.RowIndex].Value.ToString();
        string msg = string.Empty;
        if (da.ExcuteSql("update userinfo set country='"+country_ID+"' where id='" + id + "'", out msg))
        {
            grid.EditIndex = -1;
            BindGridView();
        }


    }