private void LoadCategory() { //string query = "Select * from tbl_Category"; //DataTable dt = DB.Select(query); CategoryBL objcate = new CategoryBL(); var dt = objcate.Select(); txtProdCate.DataSource = dt; txtProdCate.DisplayMember = "CategoryName"; txtProdCate.ValueMember = "CategoryID"; }
private void LoadData() { CategoryBL objCate = new CategoryBL(); List <tbl_Category> dt = objCate.Select(); dgvCategory.Columns.Clear(); if (dt != null && dt.Count > 0) { DataGridViewImageColumn edit = new DataGridViewImageColumn(); edit.Image = Properties.Resources.edit; edit.ImageLayout = DataGridViewImageCellLayout.Zoom; edit.HeaderText = "Edit"; DataGridViewImageColumn delete = new DataGridViewImageColumn(); delete.Image = Properties.Resources.delete; delete.ImageLayout = DataGridViewImageCellLayout.Zoom; delete.HeaderText = "Delete"; edit.Width = delete.Width = 20; dgvCategory.Columns.Add(edit); dgvCategory.Columns.Add(delete); dgvCategory.DataSource = dt; dgvCategory.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } }