Binding the data to combobox from sql

    string strCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    string str;

    SqlCommand com;

    SqlDataAdapter sqlda;

    DataSet ds;





    void bindstate()

    {

        SqlConnection con = new SqlConnection(strCon);

        str = "select StateId,StateName from State order by StateName asc";

        com = new SqlCommand(str, con);

        sqlda = new SqlDataAdapter(com);

        ds = new DataSet();

        sqlda.Fill(ds,"State");

        comstate.DataSource = ds.Tables["State"].DefaultView;

        comstate.ValueMember = "StateId";

        comstate.DisplayMember = "StateName";



    }



// Combobox Selected State Changed  'Start'



    bindDistrict();



// End



    void bindDistrict()

    {

        SqlConnection con = new SqlConnection(strCon);

        str = "select DistrictId,DistrictName from District where State_Id ='" + comstate.SelectedValue + "'";

        com = new SqlCommand(str, con);

        sqlda = new SqlDataAdapter(com);

        ds = new DataSet();

        sqlda.Fill(ds,"District");

        comDistrict.DataSource = ds.Tables["District"].DefaultView;

        comDistrict.ValueMember = "DistrictId";

        comDistrict.DisplayMember = "DistrictName";



    }

SATHIYANARAYANAN

SATHIYANARAYANAN