public void cargarGrid() { DataTable dt2 = new DataTable(); dt2.Columns.AddRange(new DataColumn[6] { new DataColumn("Posi", typeof(string)), new DataColumn("Sku", typeof(string)), new DataColumn("Desc", typeof(string)), new DataColumn("Cant", typeof(string)), new DataColumn("Uni", typeof(string)), new DataColumn("Esp", typeof(string)), }); foreach (var item in ped.Items) { string Posi = item.Posicion; string Sku = item.SKU; string Desc = item.Descripcion; string Cant = item.Cantidad; string Uni = item.UNIDAD; string Esp = item.Especial1; dt2.Rows.Add(Posi, Sku, Desc, Cant, Uni, Esp); } GridItems.DataSource = dt2; GridItems.DataBind(); }
protected void GridItems_PageIndexChanging(object sender, GridViewPageEventArgs e) { DataTable data = (DataTable)Cache["data"]; GridItems.DataSource = data; MediaGalleryItems.RecourdNumber = data.Rows.Count; GridItems.PageIndex = e.NewPageIndex; GridItems.DataBind(); }
private void fillComments() { DataTable dtTbl = new DataTable(); dtTbl = (new BL()).searchComments(); GridItems.PageSize = Convert.ToInt32(10); GridItems.DataSource = dtTbl; GridItems.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dtTbl = new DataTable(); dtTbl = (new BL()).searchComments(); GridItems.PageSize = Convert.ToInt32(10); GridItems.DataSource = dtTbl; GridItems.DataBind(); } }
protected void GridItems_RowDeleting(object sender, GridViewDeleteEventArgs e) { DataTable data = (DataTable)Cache["data"]; Item item = Helper.GetDatabase().GetItem(data.Rows[e.RowIndex]["ID"].ToString()); item.Delete(); data.Rows.RemoveAt(e.RowIndex); Cache["data"] = data; MediaGalleryItems.RecourdNumber = data.Rows.Count; GridItems.DataSource = data; GridItems.DataBind(); }
protected void ExportData(object sender, EventArgs e) { try { string h = txtHeight.Text; Int32.TryParse(h, out Height); string w = txtWidth.Text; Int32.TryParse(w, out Width); data = new DataTable(); Helper.SetDataTableColums(data, MediaGalleryItems.ExportedFields); MediaGalleryItems.CSV.AppendLine(Helper.GetHeader(MediaGalleryItems.ExportedFields)); using (new SecurityDisabler()) { Database masterDb = Helper.GetDatabase(); Item parent = masterDb.GetItem(txtStartPath.Text.Trim()); if (parent != null) { GetData(parent); } Cache["data"] = data; GridItems.DataSource = data; GridItems.DataBind(); Helper.CreateFile(MediaGalleryItems.CSV.ToString(), MediaGalleryItems.OutputName); } pnSuccess.Visible = true; pnFailure.Visible = false; } catch (Exception ex) { pnSuccess.Visible = false; pnFailure.Visible = true; } }