public void GVOder() { string gridtext = "select order_id,order_name from [order]"; GVList.DataSource = ConnSQL.SelectUnit(gridtext); GVList.DataBind(); }
protected void btnUpload_Click(object sender, EventArgs e) { string file = FileUpload1.FileName; if (file.EndsWith(".xlsx")) { // Reading from a binary Excel file (format; *.xlsx) string folderPath = Server.MapPath("uploads"); FileUpload1.SaveAs(folderPath + "\\" + file); FileStream stream = File.Open(folderPath + "\\" + file, FileMode.Open, FileAccess.Read); IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); DataSet result = excelReader.AsDataSet(); excelReader.Close(); GVList.DataSource = result; GVList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { string sWhere = ""; Auth.CheckPermission("MASTERDATA", "WBS"); // recupera oggetto con variabili di sessione CurrentSession = (TRSession)Session["CurrentSession"]; // Resetta indice di selezione sulle dropdwonlist per non perderlo a seguito passaggio a pagina di dettaglio if (!IsPostBack && Session["DL_progetto"] != null) { DL_progetto.DataBind(); DL_progetto.SelectedValue = Session["DL_progetto"].ToString(); // sWhere = " AND p.Projects_id = " + Session["DL_progetto"].ToString(); } // Imposta il SelectCommand in base al contenuto della lista dropdown if (DL_progetto.SelectedValue != "") { sWhere = " AND p.Projects_id = " + ASPcompatility.FormatStringDb(DL_progetto.SelectedValue); } // admin if (Auth.ReturnPermission("MASTERDATA", "PROJECT_ALL")) { DSPhase.SelectCommand = "SELECT Phase_id, Phase.PhaseCode + ' : ' + Phase.Name as NomeFase, c.name as NomeManager, Phase.Projects_id, p.ProjectCode + ' : ' + p.Name AS NomeProgetto FROM Phase INNER JOIN Projects as p ON Phase.Projects_id = p.Projects_Id " + " INNER JOIN Persons as c ON c.persons_id = p.ClientManager_id " + " WHERE p.active = 1 and activityON = 1 " + sWhere + " ORDER BY Phase.Projects_id, Phase.PhaseCode "; } else // manager { DSPhase.SelectCommand = "SELECT Phase_id, Phase.PhaseCode + ' : ' + Phase.Name as NomeFase, c.name as NomeManager, Phase.Projects_id, p.ProjectCode + ' : ' + p.Name AS NomeProgetto FROM Phase INNER JOIN Projects as p ON Phase.Projects_id = p.Projects_Id " + " INNER JOIN Persons as c ON c.persons_id = p.ClientManager_id " + " WHERE p.active = 1 and activityON = 1 and p.clientmanager_id = " + CurrentSession.Persons_id + sWhere + " ORDER BY Phase.Projects_id, Phase.PhaseCode "; } GVList.DataBind(); }