Thursday, November 28, 2013

fill drop down list from database

 private void Form1_Load(object sender, EventArgs e)
        {
            con.Open();

            SqlDataAdapter da = new SqlDataAdapter("select name from sample ", con);
            DataTable dt = new DataTable();
            da.Fill(dt);
            comboBox1.DataSource = dt ;
            comboBox1.ValueMember = "name";
            comboBox1.DisplayMember = "name";
            con.Close();

        }

No comments:

Post a Comment