C#关于ListView控件连接数据库功能应用

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