GridView与DropDownList

来源：互联网发布：手机物理模拟软件编辑：程序博客网时间：2024/05/22 08:23

前台代码：：view plaincopy to clipboardprint?
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" HeaderStyle-VerticalAlign="Middle"
                       CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Height="221px" Width="318px" CaptionAlign="Bottom">

                       <Columns>
                            <asp:BoundField DataField="CID" HeaderText="用户ID" />

                           <asp:BoundField DataField="Name" HeaderText="用户姓名" />
                           <asp:TemplateField HeaderText="员工性别">
                               <ItemTemplate>
                                   <asp:DropDownList ID="DropDownList1" runat="server" DataSource='<%# ddlbind()%>' DataValueField="Sex" DataTextField="Sex">
                                   </asp:DropDownList>
                               </ItemTemplate>
                           </asp:TemplateField>
                           <asp:BoundField DataField="Address" HeaderText="家庭住址" />

                       </Columns>
                       <RowStyle ForeColor="#000066" />
                       <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                       <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                       <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />

       </asp:GridView>
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" HeaderStyle-VerticalAlign="Middle"
                        CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Height="221px" Width="318px" CaptionAlign="Bottom">

                        <Columns>
                             <asp:BoundField DataField="CID" HeaderText="用户ID" />

                            <asp:BoundField DataField="Name" HeaderText="用户姓名" />
                            <asp:TemplateField HeaderText="员工性别">
                                <ItemTemplate>
                                    <asp:DropDownList ID="DropDownList1" runat="server" DataSource='<%# ddlbind()%>' DataValueField="Sex" DataTextField="Sex">
                                    </asp:DropDownList>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="Address" HeaderText="家庭住址" />

                        </Columns>
                        <RowStyle ForeColor="#000066" />
                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />

</asp:GridView>

后台代码：：view plaincopy to clipboardprint?
SqlConnection sqlcon;
   string strCon = "Data Source=(local);Database=wxd;Uid=sa;Pwd=sa";
   //GridView和下拉菜单DropDownList结合
   protected void Page_Load(object sender, EventArgs e)
   {
       DropDownList ddl;
       if (!IsPostBack)
       {
           string sqlstr = "select top 5 * from Admin";
           sqlcon = new SqlConnection(strCon);
           SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
           DataSet myds = new DataSet();
           sqlcon.Open();
           myda.Fill(myds, "Admin");
           GridView1.DataSource = myds;
           GridView1.DataBind();
           for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
           {
               DataRowView mydrv = myds.Tables["Admin"].DefaultView[i];
               if (Convert.ToString(mydrv["Sex"]).Trim() == "男")
               {
                   ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1");
                   ddl.SelectedIndex = 0;
               }
               if (Convert.ToString(mydrv["Sex"]).Trim() == "女")
               {
                   ddl = (DropDownList)GridView1.Rows[i].FindControl("DropDownList1");
                   ddl.SelectedIndex = 1;
               }
           }
           sqlcon.Close();
       }
   }
   public SqlDataReader ddlbind()
   {
       string sqlstr = "select distinct (Sex) from Admin";
       sqlcon = new SqlConnection(strCon);
       SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon);
       sqlcon.Open();
       return sqlcom.ExecuteReader();

   }