void showStatus() { if (!Page.IsPostBack) { InsertRequestDAO requestDAO = new InsertRequestDAO(); StatusGrid.DataSource = requestDAO.ShowRequestList(Session["Requester"].ToString()); StatusGrid.DataBind(); } }
protected void Page_PreRender(object sender, EventArgs e) { ICEDB db = new ICEDB(); DataTable dt = db.GetCheckStatus(Int32.Parse(RoutingNo), Int32.Parse(ClearingType)); StatusGrid.DataSource = dt; StatusGrid.DataBind(); try { StatusGrid.FooterRow.Cells[1].Text = dt.Compute("SUM(CheckCount)", "").ToString(); StatusGrid.FooterRow.Cells[2].Text = dt.Compute("SUM(TotalAmount)", "").ToString(); } catch { } dt.Dispose(); StatusGrid.Dispose(); }
protected void StatusGrid_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (e.CommandName.StartsWith("Move")) { Store store = AbleContext.Current.Store; store.OrderStatuses.Sort("OrderBy"); int orderStatusId = AlwaysConvert.ToInt(e.CommandArgument.ToString()); int index; switch (e.CommandName) { case "MoveUp": index = store.OrderStatuses.IndexOf(orderStatusId); if (index > 0) { OrderStatus tempStatus = store.OrderStatuses[index - 1]; store.OrderStatuses[index - 1] = store.OrderStatuses[index]; store.OrderStatuses[index] = tempStatus; } break; case "MoveDown": index = store.OrderStatuses.IndexOf(orderStatusId); if (index < store.OrderStatuses.Count - 1) { OrderStatus tempStatus = store.OrderStatuses[index + 1]; store.OrderStatuses[index + 1] = store.OrderStatuses[index]; store.OrderStatuses[index] = tempStatus; } break; } // make sure order statuses are in order index = 0; foreach (OrderStatus status in store.OrderStatuses) { status.OrderBy = (short)index; index++; } store.Save(); // rebind grid to reflect update StatusGrid.DataBind(); } }
protected void LoadGridChart2() { SqlCommand cmd = new SqlCommand("SP_GetGridData_Charts", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IMODE", SqlDbType.Int).Value = 1; DataSet dsGrid = new DataSet(); StatusGrid.DataBind(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dsGrid); if (dsGrid != null && dsGrid.Tables.Count > 0 && dsGrid.Tables[0].Rows.Count > 0) { StatusGrid.DataSource = dsGrid.Tables[0]; StatusGrid.DataBind(); } else { StatusGrid.DataSource = new String[] { }; StatusGrid.DataBind(); } }