private void Form1_Load(object sender, EventArgs e) { show_all_items(); } public void show_all_items() { lv_main.Items.Clear(); using (SQLiteConnection conn = new SQLiteConnection(strConn)) { conn.Open(); string str_select = "SELECT * FROM cars limit 30"; using (SQLiteCommand cmd = new SQLiteCommand(str_select, conn)) { using (SQLiteDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { ListViewItem item = new ListViewItem(); ImageList imgList = new ImageList(); imgList.Images.Add(LoadImage(rdr["thumnail_url"].ToString())); imgList.ImageSize = new Size(55, 40); lv_main.SmallImageList = imgList; item.ImageIndex = 0; item.SubItems.Add(rdr["carName"].ToString()); item.SubItems.Add(rdr["mission"].ToString()); item.SubItems.Add(rdr["born"].ToString()); item.SubItems.Add(rdr["gas"].ToString()); item.SubItems.Add(rdr["mile"].ToString()); item.SubItems.Add(rdr["price"].ToString()); item.SubItems.Add(rdr["color"].ToString()); DateTime regDate = (DateTime)rdr["regDate"]; item.SubItems.Add(regDate.ToShortDateString()); lv_main.Items.Add(item); } rdr.Close(); } } conn.Close(); } } private Image LoadImage(string url) { System.Net.WebRequest request = System.Net.WebRequest.Create(url); System.Net.WebResponse response = request.GetResponse(); System.IO.Stream responseStream = response.GetResponseStream(); Bitmap bmp = new Bitmap(responseStream); responseStream.Dispose(); return bmp; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)