public void UpdateItems() { SqlConnection conn = new SqlConnection(dbconn.Configuration()); SqlCommand cmd = null; SqlDataReader rdr = null; string sqlsel = "select id, headline, description, category, picture from item"; try { conn.Open(); cmd = new SqlCommand(sqlsel, conn); rdr = cmd.ExecuteReader(); GridViewItems.DataSource = rdr; GridViewItems.DataBind(); } catch (Exception ex) { LabelMessage.Text = ex.Message; } finally { conn.Close(); } }
protected void BtnZoeken_Click(object sender, EventArgs e) { if (TbSearch.Text != "") { string soort = DdlCategorie.SelectedItem.ToString(); string naam = TbSearch.Text; GridViewItems.DataSource = Connectie.GetItems(soort, naam); GridViewItems.DataBind(); if (GridViewItems.Rows.Count >= 1) { if (soort == "Personage") { GridViewItems.AutoGenerateSelectButton = false; BtnVoegToe.Visible = false; } else { BtnVoegToe.Visible = true; } } else { LbErrorZoek.Text = "Geen items met deze naam aanwezig"; LbErrorZoek.ForeColor = System.Drawing.Color.Red; LbErrorZoek.Visible = true; } } else { LbErrorZoek.ForeColor = System.Drawing.Color.Red; LbErrorZoek.Text = "Vul geldige informatie in"; LbErrorZoek.Visible = true; } }
protected void BtnShow_Click(object sender, EventArgs e) { List <Item> ItemList = new List <Item>(); PanelDetail.Visible = false; if (ddlItemID.SelectedValue == "all" && ddlDesc.SelectedValue == "all") { string category = ddlCate.SelectedValue.ToString(); ItemList = VIC.GetItemByCategory(category); PanelTable.Visible = true; Session["ItemList"] = ItemList; GridViewItems.DataSource = ItemList; GridViewItems.DataBind(); } else { string id = ddlItemID.SelectedValue.ToString(); Item i = VIC.GetItemByItemID(id); PanelTable.Visible = true; ItemList.Add(i); Session["ItemList"] = ItemList; GridViewItems.DataSource = ItemList; GridViewItems.DataBind(); } }
protected void BtnShowAll_Click(object sender, EventArgs e) { PanelDetail.Visible = false; PanelTable.Visible = true; Session["ItemList"] = VIC.GetAllItem(); GridViewItems.DataSource = VIC.GetAllItem(); GridViewItems.DataBind(); }
public SecondPageViewModel(ISampleScreen screen) : base(screen) { for (int i = 0; i < 500; i++) { GridViewItems.Add(new GridViewItem(i)); } NavigateBack = ReactiveCommand.CreateFromObservable( () => HostScreen.Router.NavigateBack.Execute(Unit.Default)); }
protected void btnEdit_Click(object sender, EventArgs e) { if (GXGridView1.SelectedIndex != -1) { int id = Convert.ToInt32(GXGridView1.SelectedValue); BrokeragesForMarketingAgent bfma = BrokeragesForMarketingAgent.Get(id); tbUserID.Text = bfma.UserID.ToString(); tbName.Text = Broker.DataAccess.User.GetUserById(bfma.UserID).Name; odsGridViewItems.SelectParameters.Clear(); odsGridViewItems.SelectParameters.Add("UserID", bfma.UserID.ToString()); GridViewItems.DataBind(); mvMain.SetActiveView(ViewInsertBrokerages); mvBrokerages.SetActiveView(viewItemsGrid); btnNew.CssClass = "novZapis"; btnEdit.CssClass = "izmeni_Active"; btnPreview.CssClass = "osvezi"; btnReport.CssClass = "izvestaj"; btnSearch.CssClass = "prebaraj"; } }
protected void DetailsViewItems_ItemInserted(object sender, DetailsViewInsertedEventArgs e) { if (e.Exception != null) { e.ExceptionHandled = true; e.KeepInInsertMode = true; ValidationUtility.ShowValidationErrors(this, e.Exception); } else { int offerID = Convert.ToInt32(e.Values["UserID"]); //decimal offerItemCost = Convert.ToDecimal(e.Values["Cost"]); //Offer o = Offer.Get(offerID); //o.Cost += offerItemCost; //Offer.Table.Context.SubmitChanges(); //odsOfferPreview.SelectParameters.Clear(); //odsOfferPreview.SelectParameters.Add("id", offerID.ToString()); //dvOfferPreview.DataBind(); odsGridViewItems.SelectParameters.Clear(); odsGridViewItems.SelectParameters.Add("userID", offerID.ToString()); GridViewItems.DataBind(); mvBrokerages.SetActiveView(viewItemsGrid); } }
protected void DetailsViewItems_ItemInserted(object sender, DetailsViewInsertedEventArgs e) { GridViewItems.DataBind(); }
protected void GridViewItems_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridViewItems.PageIndex = e.NewPageIndex; GridViewItems.DataSource = Session["ItemList"]; GridViewItems.DataBind(); }