GridView和下拉菜单DropDownList结合

时间:2009-03-26    点击:2540   

OnRowDataBound="GridView1_RowDataBound"

              <asp:TemplateField HeaderText="员工性别">
                <ItemTemplate>
                   <asp:DropDownList ID="DDsex" runat="server" DataSource='<%# sexbind()%>' DataValueField="sex" DataTextField="sex">
                   </asp:DropDownList>
                </ItemTemplate>
              </asp:TemplateField>

public OleDbDataReader sexbind()
    {
        string sql = "select distinct sex from [user]";
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb"));
        OleDbCommand cmd = new OleDbCommand(sql, conn);
        conn.Open();
        return cmd.ExecuteReader();
    }


    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowIndex >= 0)
        {
            string sex = e.Row.Cells[4].Text;

            DropDownList ddsex = (DropDownList)e.Row.Cells[3].FindControl("DDsex");

            ddsex.Text = sex;

           
        }

        if ((e.Row.RowType == DataControlRowType.DataRow) || (e.Row.RowType == DataControlRowType.Header) || (e.Row.RowType == DataControlRowType.Footer))
        {
            e.Row.Cells[4].Visible = false;
        }


    }

演示 下载
GridView求和求平均值
GridView合并表头
GridView固定表头
GridView正反双向排序
GridView选中,编辑,取消,删除
> 返回     
地址:上海市普陀区胶州路941号长久商务中心 电话: QQ:
© Copyright 2012 上海网络 All Rights Reserved