listview连接mysql_向listview控件中添加数据库数据

//连接字符串

string str = "Data Source=.;Initial Catalog=mu;User ID=sa;Password=111";

//创建数据库连接

SqlConnection con =new SqlConnection(str);

//打开数据库

con.Open();

//创建sql语句

string sql = "select studentName,addres,borndate from student";

//创建command命令

SqlCommand com = new SqlCommand(sql,con);

//执行sql语句

SqlDataReader dr = com.ExecuteReader();

while(dr.Read()){

string name = dr["studentName"].ToString();

string addres = dr["addres"].ToString();

string date = dr["borndate"].ToString();

//创建listView对象

ListViewItem item = new ListViewItem(name);

item.SubItems.Add(addres);

item.SubItems.Add(date);

listView1.Items.Add(item);

}

//关闭数据库

con.Close();