点击下拉列表循环读取

点击下拉列表循环读取

    private void comboBox1_Click(objectsender, EventArgs e)

        {

            conn.ConnectionString = cons;

            strcon = "selectdistinct userid as用户id from T_user ";

            conn.Open();

            cmd = newSqlCommand(strcon, conn);

            SqlDataReader Sdr =cmd.ExecuteReader();

            comboBox1.Items.Clear();

            while(Sdr.Read())

            {

               comboBox1.Items.Add(Sdr[0].ToString());

            }

            Sdr.Close();

            conn.Close();

        }