如何根据下拉列表中的选择在gridview中显示数据 [英] how to show data in gridview based on the selection on dropdown list

问题描述

我有一个这样的下拉列表

I have a dropdown list like this

<asp:DropDownList ID="ddlPortal2" runat="server" AutoPostBack="True">
        <asp:ListItem>Select</asp:ListItem>
        <asp:ListItem>TRAVELONG</asp:ListItem>
        <asp:ListItem>ONETRAVEL</asp:ListItem>
    </asp:DropDownList>

和带有sqlconnection的网格视图：

and a grid view with sqlconnection:

<asp:GridView ID="GridView1" runat="server"    CellPadding="4" ForeColor="#333333"

        GridLines="None" onrowcommand="GridView1_RowCommand"

        AutoGenerateColumns="False">
        <Columns>
       <asp:BoundField DataField="Portal" HeaderText="Portal" />
        <asp:BoundField DataField="TID" HeaderText="TID" />
        <asp:BoundField DataField="PNR" HeaderText="PNR" />
        <asp:BoundField DataField="TicketNumber" HeaderText="Ticket Number" />
        <asp:BoundField DataField="ESACCode" HeaderText="ESACCode" />
        <asp:BoundField DataField="WaiverCode" HeaderText="WaiverCode" />
        <asp:BoundField DataField="Remarks" HeaderText="Remarks" />
        <asp:BoundField DataField="UnusedTicketAmount" HeaderText="UnusedTicketAmount" />
        <asp:BoundField DataField="ddlUnusedAmount" HeaderText="ddlUnusedAmount" />
        <asp:BoundField DataField="AirlinePenality" HeaderText="AirlinePenality" />
        <asp:BoundField DataField="ddlAirlinePenality" HeaderText="ddlAirlinePenality" />
        <asp:BoundField DataField="NetRefundProcess" HeaderText="NetRefundProcess" />
        <asp:BoundField DataField="ddlNetRefundProcess" HeaderText="ddlNetRefundProcess" />
        <asp:BoundField DataField="RefundableCommission" HeaderText="RefundableCommission" />
        <asp:BoundField DataField="ddlRefundableCommission" HeaderText="ddlRefundableCommission" />
        <asp:BoundField DataField="CouponRefunded" HeaderText="CouponRefunded" />
        <asp:BoundField DataField="RefundType" HeaderText="RefundType" />
    </Columns>
 <asp:SqlDataSource ID="SqlDataSource1" runat="server"

        ConnectionString="<%$ ConnectionStrings:BartConnectionString %>"

        SelectCommand="SELECT select * [Test]">
        </asp:SqlDataSource>

现在如果我有多个值Travelong在我的数据库中，当我从下拉列表中选择Travelong并按下搜索按钮时，gridview中显示的所有数据都可以告诉我如何做到这一点。我怎么能提前感谢

Now if i have more than one value of Travelong in my database and when i select Travelong from my dropdown list and press search button all the data show in the gridview can any one tell me how to do that. how can i do that thanks in advance

推荐答案

ConnectionStrings：BartConnectionString ％>

SelectCommand = SELECT select * [Test] >
< / asp：SqlDataSource >

ConnectionStrings:BartConnectionString %>" SelectCommand="SELECT select * [Test]"> </asp:SqlDataSource>

现在，如果我有一个以上在我的数据库中以及当我选择Tr时，Travelong的价值从我的下拉列表中按下avelong并按下搜索按钮gridview中显示的所有数据都可以告诉我如何做到这一点。我怎么能提前谢谢

Now if i have more than one value of Travelong in my database and when i select Travelong from my dropdown list and press search button all the data show in the gridview can any one tell me how to do that. how can i do that thanks in advance

你可以通过在 yourpage.aspx.cs 中按钮点击添加代码来实现这个目的。
这是一个示例代码

You can do this by adding code on button click in yourpage.aspx.cs
here is a sample code

protected void BtnSerch_Click(object sender, EventArgs e)
{
 DataSet Ds = new DataSet();
 SqlDataAdapter Da = new SqlDataAdapter();
 SqlConnection Con;

 if (DropDownList1.SelectedIndex !=0)
 {
  Con = new SqlConnection(" your Connextion String");
  Con.Open();
  Da = new SqlDataAdapter(" select * from yourtable where ColumnName =	''"+DropDownList1.SelectedItem.Text+"'' ",Com); 
  Da.Fill(Ds);
  GridView1.DataSource=Ds;
  GridView1.DataBind();

  Con.Close();


 }

}

这篇关于如何根据下拉列表中的选择在gridview中显示数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！