how to show data in gridview based on the selection on dropdown list

Question

0.00/5 (No votes)

See more:

ASP.NET

Gridview

table

, +

I have a dropdown list like this

XML

<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>

and a grid view with sqlconnection:

XML

<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>

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

Posted 27-Mar-13 21:53pm

amitesh1989

Updated 27-Mar-13 21:55pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Susheel Kumar Verma · Accepted Answer · 2013-03-27T22:54:00

Solution 1

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();


 }

}

Posted 27-Mar-13 22:54pm

Susheel Kumar Verma

Comments

amitesh1989 28-Mar-13 6:06am

i get this error Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition.

[no name] 28-Mar-13 6:28am

if you are using code behind then you have to remove

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:BartConnectionString %>"
SelectCommand="SELECT select * [Test]">

from your .aspx page

amitesh1989 28-Mar-13 6:48am

if i am not using sqlconnection than i guess i have to bind boundfield with gridview field am i rite !!!???

amitesh1989 28-Mar-13 6:49am

cause when i use this i got this error Invalid column name 'TRAVELONG'.

[no name] 28-Mar-13 8:40am

please make sure that column name of your sql table is same as 'TRAVELONG'

[no name] 28-Mar-13 8:39am

no need to use boundfield.

amitesh1989 28-Mar-13 8:57am

thanks i made some changes and it work thanks for your reply

[no name] 28-Mar-13 12:09pm

welcome.