C#关于ListView控件连接数据库功能应用
#region 数据库连接字符串 //string findatabase = Application.StartupPath + "//数据库名称"; string lianjieshujuku = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=密码;Data Source=数据库名称"; #endregion #region 连接数据库 OleDbConnection con = new OleDbConnection(lianjieshujuku); OleDbCommand cmd = new OleDbCommand("Select * from 表名", con); con.Open(); OleDbDataReader read = cmd.ExecuteReader(); while (read.Read()) { ListViewItem item = new ListViewItem(read[0].ToString()); item.SubItems.Add(read[1].ToString()); this.listView1.Items.Add(item); } con.Close(); con.Dispose(); } #endregion |