关于在GridView模版里添加DropDownList实现根据下拉列表的不同选择gridview根据条件筛选显示。

时间:2025-01-27 07:12:46

 <div>
        &nbsp;<asp:GridView ID="GridView1"
        runat="server"
        BackColor="White"
        BorderColor="#DEDFDE"
        BorderStyle="None"
        BorderWidth="1px"
        CellPadding="4"
        ForeColor="Black"
        GridLines="Vertical"
        OnRowCreated="GridView1_RowCreated">
            <Columns>
                <asp:TemplateField>
                 <HeaderTemplate>
                  <asp:DropDownList
                   runat="server"
                   ID="dropdownlist1"
                   BackColor="NavajoWhite"
                   AutoPostBack="true"
                   >
                  <asp:ListItem Value="0" Text=" "/>
                  <asp:ListItem Value="1" Text="整箱"/>
                  <asp:ListItem Value="2" Text="散货"/>
                  <asp:ListItem Value="3" Text="自拼"/>
                  </asp:DropDownList>
                 </HeaderTemplate>
                </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="#CCCC99" />
            <RowStyle BackColor="#F7F7DE" />
            <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
            <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
       </div>

using System;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
using ;

public partial class Test_RowFilter :
{
    SqlConnection conn = new SqlConnection(["connectionString"]);
    DataView dv = new DataView();
    DropDownList ddl;
    protected void Page_Load(object sender, EventArgs e)
    {
       if (!)
       {
           BindData();
          
       }
   }
   void BindData()
    {
        string sql = "select top 20 JobNo,DeptName,JobType,InputDate,AttnName from viewjobse";
        ();
        SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        (ds, "RusTable");
        dv = ["RusTable"].DefaultView;
        = dv;
        ();
        ();
    }
   
    protected void dropdownlist1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList ddl= sender as DropDownList;
        string selectedText = ;
        BindData();
        switch ()
        {
            case "整箱":
                = "jobtype='" + + "'";
                = dv;
                ();
                break;
            case "散货":
                = "jobtype='" + + "'";
                = dv;
                ();
                break;
            case "自拼":
                = "jobtype='" + + "'";
                = dv;
                ();
                break;
            default:
                BindData();
                break;
        }
    }

    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
       if ( == )
        {
            DropDownList ddl = (DropDownList)("dropdownlist1");
            += new EventHandler(dropdownlist1_SelectedIndexChanged);
        }
        if ( == )
        {
            [0].BackColor = ;
        }
    }

}