dropdownlist data bind

Bhabani prasad Dash

protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e)
    {
        cmd = new SqlCommand("select City from Mst_City where State='"+DDLstate.SelectedValue+"'",con);
        da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Mst_City");
        DDLcity.DataSource = ds;
        DDLcity.DataBind();

    }
here in above code data retrived when am debugging but it will show system.data.datarowview in dropdownlist when am change in state from state dropdownlist

3 Replies

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

Satyapriya Nayak13y ago
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 Country_state_city { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bindcountry(); } } protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e) { bindstate(); } protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e) { bindcity(); } public void bindcountry() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select CountryId,CountryName from Country"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "Country"); ddlcountry.Items.Clear(); ddlcountry.Items.Add("--Select--"); ddlcountry.DataValueField = "CountryId"; ddlcountry.DataTextField = "CountryName"; ddlcountry.DataSource = ds; ddlcountry.DataMember = "Country"; ddlcountry.DataBind(); con.Close(); } public void bindstate() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select StateId,StateName from State where Country_Id='" + ddlcountry.SelectedValue + "'"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "State"); ddlstate.Items.Clear(); ddlstate.Items.Add("--Select--"); ddlstate.DataValueField = "StateId"; ddlstate.DataTextField = "StateName"; ddlstate.DataSource = ds; ddlstate.DataMember = "State"; ddlstate.DataBind(); con.Close(); } public void bindcity() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select CityId,CityName from City where State_Id ='" + ddlstate.SelectedValue + "'"; com = new SqlCommand(str, con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "City"); ddlcity.Items.Clear(); ddlcity.Items.Add("--Select--"); ddlcity.DataValueField = "CityId"; ddlcity.DataTextField = "CityName"; ddlcity.DataSource = ds; ddlcity.DataMember = "City"; ddlcity.DataBind(); con.Close(); } } }
0
Pankaj Pandey13y ago
hello

try this...

protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e)
    {
        cmd = new SqlCommand("select City from Mst_City where State='"+DDLstate.SelectedValue+"'",con);
        da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Mst_City");
        DDLcity.DataSource = ds;
DDLcity.DataTextField="Mst_City";
     DDLcity.DataValueField ="Mst_City";
        DDLcity.DataBind();

}


or

protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e)
    {
        cmd = new SqlCommand("select City from Mst_City where State='"+DDLstate.SelectedValue+"'",con);
        da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Mst_City");

DDLcity.DataTextField="Mst_City";
     DDLcity.DataValueField ="Mst_City";
DDLcity.DataSource = ds;
        DDLcity.DataBind();

}

I hope it will help you.

Mark as answered if helpfull
0
Bhabani prasad Dash13y ago
i got my answer thanks Bhabani

protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e)
    {
        cmd = new SqlCommand("select City from Mst_City where State='"+DDLstate.SelectedValue+"'",con);
        da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Mst_City");
        DDLcity.DataSource = ds.Tables["Mst_City"];
       // DDLcity.DataTextField = "City"; // This is text displayed
        DDLcity.DataValueField = "City"; // This is the value returned
        DDLcity.DataBind();
    }
0