private void btnCateSearch_Click(object sender, EventArgs e) { try { _botcat.Event = "GETALL"; List <BOTopCategory> predict = _batcat.SelectTopCategoryList(_botcat); if (!string.IsNullOrEmpty(txtCateSearch.Text)) { predict = predict.Where(topcate => topcate.TopCategoryName.ToUpper().Contains(txtCateSearch.Text.ToUpper())).ToList(); } int Snu = 0; DataTable _table = new DataTable(); _table = Common.LINQToDataTable(predict); dgvTopCategory.Rows.Clear(); foreach (DataRow row in _table.Rows) { dgvTopCategory.Rows.Add(); dgvTopCategory.Rows[Snu].Cells[0].Value = Convert.ToString(row["TopCategoryId"]); dgvTopCategory.Rows[Snu].Cells[1].Value = Convert.ToString(row["TopCategoryName"]); ++Snu; } dgvTopCategory.ReadOnly = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FillTopCategory() { BOTopCategory _botopcat = new BOTopCategory(); _botopcat.Event = "GETALL"; List <BOTopCategory> TCateList = btcat.SelectTopCategoryList(_botopcat); cmbTopCategory.DataSource = TCateList; cmbTopCategory.DisplayMember = "TopCategoryName"; cmbTopCategory.ValueMember = "TopCategoryID"; }
private void FillTopddlCategory() { BATopCategory batcat = new BATopCategory(); DataTable _datatable3 = new DataTable(); _datatable3 = batcat.SelectTopCategoryList("GETALL"); ddlTopCategory.DataTextField = "TopCategoryName"; ddlTopCategory.DataValueField = "TopCategoryID"; ddlTopCategory.DataSource = _datatable3; ddlTopCategory.DataBind(); FillSecondddlCategory(ddlTopCategory.SelectedItem.Value); }
private void FilldropDowntopCategory() { BATopCategory _batopcat = new BATopCategory(); DataTable _table = new DataTable(); _table = _batopcat.SelectTopCategoryList("GETALL"); drpTopCategory.DataTextField = "TopCategoryName"; drpTopCategory.DataValueField = "TopCategoryID"; drpTopCategory.DataSource = _table; drpTopCategory.DataBind(); FilldropDownSecondCategory(drpTopCategory.SelectedItem.Value); }
private void Bind_TopCategoryCombo() { BOTopCategory _botopcat = new BOTopCategory(); BATopCategory _batopcat = new BATopCategory(); _botopcat.Event = "GETALL"; List<BOTopCategory> TCateList = _batopcat.SelectTopCategoryList(_botopcat); if (TCateList.Count > 0) { cmbTopcat.DataSource = TCateList; cmbTopcat.DisplayMember = "TopCategoryName"; cmbTopcat.ValueMember = "TopCategoryID"; } }
private void FilldropDowntopCategory() { BATopCategory _batopcat = new BATopCategory(); _datatable = new DataTable(); _datatable = _batopcat.SelectTopCategoryList("GETALL"); if (_datatable.Rows.Count > 0) { drpTopcategory.DataTextField = "TopCategoryName"; drpTopcategory.DataValueField = "TopCategoryID"; drpTopcategory.DataSource = _datatable; drpTopcategory.DataBind(); } }
private DataTable FillddlTopCategory() { BATopCategory batcat = new BATopCategory(); DataTable _datatable3 = new DataTable(); if (ViewState["dtTopCat"] != null && !ViewState["dtTopCat"].Equals("")) { _datatable3 = (DataTable)ViewState["dtTopCat"]; } else { _datatable3 = batcat.SelectTopCategoryList("GETALL"); ViewState["dtTopCat"] = _datatable3; } return(_datatable3); }
private void FillTopCategoryCombo() { BOTopCategory _botopcat = new BOTopCategory(); BATopCategory _batopcat = new BATopCategory(); _botopcat.Event = "GETALL"; List <BOTopCategory> TCateList = _batopcat.SelectTopCategoryList(_botopcat); if (TCateList.Count > 0) { cmbTopcate.DataSource = TCateList; cmbTopcate.DisplayMember = "TopCategoryName"; cmbTopcate.ValueMember = "TopCategoryID"; FillSecondCategoryCombo("GetWithTopCatId", Convert.ToInt32(cmbTopcate.SelectedValue)); } }