string dbConStr = ConfigurationManager.ConnectionStrings["dbConStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(dbConStr))
{
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM UserInfo";// where UserName like ‘%a%‘";
// cmd.Parameters.AddWithValue()
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
label1.Text = reader.GetValue(1).ToString();
List<string> list = new List<string>();
// string a = reader.GetValue(0).ToString();
// label1.Text = a;
// reader.FieldCount
MessageBox.Show(reader.FieldCount.ToString());
ArrayList list1 = new ArrayList();
for (int i = 0; i < reader.FieldCount; i++)
{
// comboBox1.Items.Add(reader.GetName(i));
list.Add(reader.GetName(i));
// comboBox1.DisplayMember = "ABCD";
// label1.Text += reader.GetName(i);
}
//list1.Add(new DictionaryEntry("szf", "身份证"));
//list1.Add(new DictionaryEntry("username", "用户名"));
//list1.Add(new DictionaryEntry("sfz", "身份Y证号"));
//list1.Add(new DictionaryEntry("Tel", "电话号码"));
comboBox1.DataSource = list;
// comboBox1.ValueMember = "UserId";
comboBox1.DisplayMember = "UserId";
}
原文：https://www.cnblogs.com/nymz/p/14213909.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群