private void button2_Click(object sender, EventArgs e)
{
//MYSQL数据库信息
string constr = "server=127.0.0.1;User Id=root;password=701108yw;Database=test";
//连接并打开数据库
MySqlConnection mycon = new MySqlConnection(constr);
mycon.Open();
//执行MySQL指令
string sql = "select * from testbiao "; //"insert into biao1(用户ID,文本) values('20','文本')";
MySqlCommand mycmd = new MySqlCommand(sql, mycon);
MySqlDataReader reader=mycmd.ExecuteReader();
//ListView显示数据控件应用
listView1.Items.Clear();
listView1.Columns.Add("选择");//listView1的CheckBoxes属性为true;
listView1.Columns.Add("姓名");
listView1.Columns.Add("年龄");
listView1.Columns.Add("身份证号");
listView1.Columns.Add("单位名称");
listView1.Columns.Add("报考时间");
listView1.View = View.Details;
while (reader.Read())
{
ListViewItem lv = new ListViewItem();
lv.SubItems.Add(reader["name"].ToString());
lv.SubItems.Add(reader["age"].ToString());
lv.SubItems.Add(reader["name"].ToString());
lv.SubItems.Add(reader["name"].ToString());
lv.SubItems.Add(reader["name"].ToString());
lv.SubItems.Add(reader["name"].ToString());
listView1.Items.Add(lv);
listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);//根据内容调整列宽
}
mycon.Close();
}
}
