How to display data in a gridview which selected by a dropdown list ?

Question

0.00/5 (No votes)

See more:

I got the output for only first index of the drop down list. When I select the next index , it refresh the whole page and no response. How to get data for for all other indexes in the drop down list?

Posted 9-Sep-12 22:45pm

gayani dassa

Add a Solution

Comments

Sunil Kumar Pandab 10-Sep-12 5:03am

Share your code so that we can clarify your problem.

4 solutions

Solution 2

Hi,

If you are trying to bind your grid view based on dropdown, then-

As per my understanding, in your dropdown first option is the default selected one.Also, the binding of dropdown should be happening in pageload.

Try,
binding your dropdown in if(!IsPostback) of the pageload.

Hope this helps.
Please post your code so that we can help with the correct solution.

Posted 9-Sep-12 23:11pm

manognya kota

Updated 9-Sep-12 23:14pm

v2

Comments

gayani dassa 10-Sep-12 5:18am

yeah. I have use if(!IsPostBack)method. I will post my code . thank you.

gayani dassa 10-Sep-12 5:41am

//code of relevant page
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = dba.getsupname();
g_ddl_supplier.DataSource = dt;
g_ddl_supplier.DataValueField = "Sup_Name";
g_ddl_supplier.DataTextField = "Sup_Name";
g_ddl_supplier.DataBind();

}
protected void g_ddl_supplier_SelectedIndexChanged(object sender, EventArgs e)
{
string name = g_ddl_supplier.Text;

DataSet ds = dba.getsupname1(name);
GridView2.DataSource = ds.Tables["Equipment"].DefaultView;
GridView2.DataBind();

}

//in DB Access class
public DataSet getsupname1(string sname)
{

if (conn.State.ToString() == "Closed")
{
conn.Open();
}

SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.CommandType = CommandType.Text;

newCmd.CommandText = "SELECT Sup_Name,Equip_Type,SerialNo FROM Equipment WHERE Sup_Name ='"+ sname +"'";
newCmd.ExecuteNonQuery();

SqlDataAdapter dr = new SqlDataAdapter(newCmd);
DataSet ds = new DataSet();
dr.Fill(ds, "Equipment");

conn.Close();
return ds;
}

manognya kota 10-Sep-12 5:47am

i dint find
if(!IsPostBack)method in your pageload event.

try,

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostback)
{
DataTable dt = dba.getsupname();
g_ddl_supplier.DataSource = dt;
g_ddl_supplier.DataValueField = "Sup_Name";
g_ddl_supplier.DataTextField = "Sup_Name";
g_ddl_supplier.DataBind();
}

}

gayani dassa 10-Sep-12 6:05am

now its working for the other indexes in the drop down list except first index.

manognya kota 10-Sep-12 6:54am

What is not working?Did you put a breakpoint and check what value is selected is actually passed to getsupname1(string sname) method?Which index is set as default?

Solution 5

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownList1.DataSource = GetData();
DropDownList1.DataValueField = "orderID";
DropDownList1.DataTextField = "OrderAmount";
DropDownList1.DataBind();
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
using (SqlConnection Cn = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
{
using (SqlCommand Cmd = new SqlCommand("select * from ODetails where orderID= @orderid", Cn))
{
Cn.Open();

Cmd.Parameters.AddWithValue("@orderid", int.Parse(DropDownList1.SelectedValue));
SqlDataReader Dr = Cmd.ExecuteReader();
if (Dr.HasRows)
{
GridView1.DataSource = Dr;
GridView1.DataBind();
}
Dr.Close();

Cn.Close();
}

}
}
DataTable GetData()
{
DataTable dt = new DataTable();
using (SqlConnection Cn = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
{
using (SqlCommand Cmd = new SqlCommand("SELECT * FROM Orders ", Cn))
{
Cn.Open();
SqlDataAdapter adpt = new SqlDataAdapter(Cmd);
adpt.Fill(dt);
}

}
return dt;
}

Posted 28-Oct-15 23:36pm

Ananta priya

Comments

AnvilRanger 29-Oct-15 7:45am

Answering a question that is 3 years old that already has an accepted solution is considered spam and can lead to getting your account banned.

It is even worse to just copy and paste that accepted solution as your own.

Solution 1

On selected index change of dropdown filter your gridview datasource according to the selected value of dropdown and bind it. Use just like this in your SelectedIndexChanged event of dropdown:

C#

var query = from c in YoourDataTable.AsEnumerable() where c.Field<string>("ID") == ddl.SelectedValue.ToString() select s;
GridView1.DataSource = query;
GridView1.DataBind();

--Amit

Posted 9-Sep-12 23:09pm

_Amy

Updated 9-Sep-12 23:19pm

v2

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)

Mohamed Mitwalli · Accepted Answer · 2012-09-09T23:59:00

Hi ,
Check this Example

C#

protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           DropDownList1.DataSource = GetData();
           DropDownList1.DataValueField = "orderID";
           DropDownList1.DataTextField = "OrderAmount";
           DropDownList1.DataBind();
       }
   }
   protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
   {
       using (SqlConnection Cn = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
       {
           using (SqlCommand Cmd = new SqlCommand("select * from ODetails where orderID= @orderid", Cn))
           {
               Cn.Open();

               Cmd.Parameters.AddWithValue("@orderid", int.Parse(DropDownList1.SelectedValue));
               SqlDataReader Dr = Cmd.ExecuteReader();
               if (Dr.HasRows)
               {
                   GridView1.DataSource = Dr;
                   GridView1.DataBind();
               }
               Dr.Close();

               Cn.Close();
           }

       }
   }
   DataTable GetData()
   {
       DataTable dt = new DataTable();
       using (SqlConnection Cn = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
       {
           using (SqlCommand Cmd = new SqlCommand("SELECT * FROM  Orders ", Cn))
           {
               Cn.Open();
               SqlDataAdapter adpt = new SqlDataAdapter(Cmd);
               adpt.Fill(dt);
           }

       }
       return dt;
   }

XML

<div>
    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
        onselectedindexchanged="DropDownList1_SelectedIndexChanged">
    </asp:DropDownList>
    <br />
    <asp:GridView ID="GridView1" runat="server">
    </asp:GridView>
</div>

Best Regards
M.Mitwalli

How to display data in a gridview which selected by a dropdown list ?

4 solutions

Solution 4

Solution 2

Solution 5

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us