private void SearchProducts() { ProductORM prodORM = new ProductORM(); dtListProducts.DataSource = prodORM.ProductSearch(Request.Form["Search"]); dtListProducts.DataBind(); }
void ListViewProductFill(int categoryID, string searchText) { try { lstwProducts.Items.Clear(); ProductORM prodORM = new ProductORM(); DataTable dt = prodORM.ProductSearch(categoryID, searchText); foreach (DataRow item in dt.Rows) { ListViewItem li = new ListViewItem(); li.Tag = item["ProductID"].ToString(); li.Text = item["ProductName"].ToString(); li.SubItems.Add(item["UnitPrice"].ToString()); li.SubItems.Add(item["QuantityPerUnit"].ToString()); if (Convert.ToInt32(item["UnitsInStock"]) < 15) { li.SubItems.Add(item["UnitsInStock"].ToString()); li.BackColor = Color.Red; } else { li.SubItems.Add(item["UnitsInStock"].ToString()); } li.SubItems.Add(item["CategoryName"].ToString()); lstwProducts.Items.Add(li); } lstwProducts.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); } catch (SqlException ex) { MessageBox.Show(ex.Message); MessageBox.Show("Ürünleri Listeleme İşleminde Bir Hata İle Karşılaşıldı"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }