Retrieve data Grideview when SelectedIndexChanged

ToBe

Hi everybody

I have dropdown list contain all the University inserted in my database and I want when the event SelectedIndexChanged clicked to show a grideview contain data related to the selected item I created the gridview and I wrote this code when SelectedIndexChanged

protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)

{

string Grdvw = GridView1.Visible.ToString();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ToBe13y ago

Dear Satyapriya thank you for your reply i applied it to my code like the following but nothing happen to the page only the dropdownlist is shown :(

Please Chose your Area:	DataSourceID="SqlDataSource3" DataTextField="Area_Name" DataValueField="Uni_ID">	Please Chose the Street:	DataSourceID="SqlDataSource4" DataTextField="University_Name" DataValueField="Uni_ID" AutoPostBack="True" onselectedindexchanged="DropDownList3_SelectedIndexChanged">

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace UNIV_System
{
    public partial class BY_UNI: System.Web.UI.Page
    {

        string strConnString = ConfigurationManager.ConnectionStrings["UNIConnectionString"].ConnectionString;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;

        protected void Page_Load(object sender, EventArgs e)
        {

            SqlConnection con = new SqlConnection(strConnString);
            if (!IsPostBack)
            {
                DropDownList3.Items.Add("Choose Id");<--what do you mean by choose Id
                con.Open();
                str = "select * from tblUni";
                com = new SqlCommand(str, con);

                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    DropDownList3.Items.Add(reader["Ser_no"].ToString());
                }
                reader.Close();
                con.Close();
            }
        }

        protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
        {

            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select * from tblUni
where Ser_no='" + DropDownList3.SelectedItem.Text + "'";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(str, con);
            ds = new DataSet();
            sqlda.Fill(ds, "tblUni ");
            GridView1.DataMember = "tblUni ";
            GridView1.DataSource = ds;
            GridView1.DataBind();
            con.Close();

        }

    }
}

Satyapriya Nayak13y ago
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Dropdownlist_gridview._Default" %>

    Untitled Page





                    onselectedindexchanged="DropDownList1_SelectedIndexChanged">








using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Dropdownlist_gridview
{
    public partial class _Default : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;


        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(strConnString);
            if (!IsPostBack)
            {
                DropDownList1.Items.Add("Choose Id");
                con.Open();
                str = "select * from employee";
                com = new SqlCommand(str, con);

                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    DropDownList1.Items.Add(reader["empid"].ToString());
                }
                reader.Close();
                con.Close();
            }
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select * from employee where empid='" + DropDownList1.SelectedItem.Text + "'";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(str,con);
            ds = new DataSet();
            sqlda.Fill(ds, "employee");
            GridView1.DataMember = "employee";
            GridView1.DataSource = ds;
            GridView1.DataBind();
            con.Close();
        }
    }
}
0