01.Database myDB = new Database();
02.SqlCeConnection conn = new SqlCeConnection(myDB.Conn);
03.try {
04. SqlCeCommand cmd = new SqlCeCommand(strSQL, conn);
05. conn.Open();
06. SqlCeDataReader rd = default(SqlCeDataReader);
07. rd = cmd.ExecuteReader();
08. while (rd.Read()) {
09. imageList1.Images.Add(new Bitmap("\\Program Files\\Image\\" + rd("idx").ToString() + ""));
10.
11. this.listView1.Items.Add(new ListViewItem(rd("nme").ToString()));
12. }
13. rd.Close();
14. this.listView1.LargeImageList = imageList1;
15. this.listView1.SmallImageList = imageList1;
16.} catch (Exception ex) {
17. MessageBox.Show(ex.Message);
18.} finally {
19. conn.Close();
20. conn.Dispose();
21.}
