protected void SearchStudentBtn_Click(object sender, EventArgs e) { StudentService service = new StudentService(); ResultsGrid.DataSource = service.Search(s => s.Name.Contains(NameTxt.Text)); ResultsGrid.DataBind(); }
protected void ShowOtherData(string DataArg, string DataMessage) { ClearPageMessages(); try { ResultPanel.Visible = true; ResultEditUpdatePanel.Visible = false; DisableEdit.Value = "1"; dt = CheckError(mrpCalc.WorkProcessResults(ProcessID.Value.ToString(), DataArg)); if ((dt != null) && (dt.Rows.Count > 0)) { ResultsGrid.Visible = true; ResultsGrid.DataSource = dt; Session["MRPResults"] = dt; } else { ShowPageMessage(DataMessage, 1); } ResultsGrid.DataBind(); MainUpdatePanel.Update(); } catch (Exception ex) { ShowPageMessage("OtherData Error " + ex.Message.ToString(), 2); } }
private void FillGrid() { try { ResultPanel.Visible = true; ResultEditUpdatePanel.Visible = false; DisableEdit.Value = "0"; ShowPageMessage("Results for process " + ProcessID.Value + ".", 0); dt = CheckError(mrpCalc.WorkProcessResults(ProcessID.Value.ToString(), "Fed")); if ((dt != null) && (dt.Rows.Count > 0)) { ResultsGrid.Visible = true; ResultsGrid.DataSource = dt; ResultsGrid.DataBind(); Session["MRPResults"] = dt; MainUpdatePanel.Update(); } else { ShowPageMessage("No Results were produced", 0); } } catch (Exception ex) { ShowPageMessage("Fill Error " + ex.Message.ToString(), 0); } }
private void ShowResults(DataTable dataTable) { //dataTable.Columns["reference"]. ResultsGrid.DataSource = dataTable; ResultsGrid.DataBind(); ResultsGrid.Visible = true; ResultsGrid.HeaderRow.TableSection = TableRowSection.TableHeader; MessageLabel.Visible = false; }
private void RunReport() { DataTable report = GetReport(); string[] columns = report.Columns.Cast <DataColumn>().Select(c => c.ColumnName).ToArray(); // build header HeaderRptr.DataSource = columns; HeaderRptr.DataBind(); // build results ResultsGrid.DataSource = report; ResultsGrid.DataBind(); }
public void SortResultsGrid(Object sender, GridViewSortEventArgs e) { try { // Create a DataView from the Results DataTable. DataView dv = new DataView((DataTable)Session["MRPResults"]); dv.Sort = e.SortExpression; ResultsGrid.DataSource = dv; ResultsGrid.DataBind(); //ResultsGrid.Height = new Unit(double.Parse(ResultsGridHeightHidden.Value), UnitType.Pixel); //ResultsGrid.Width = new Unit(double.Parse(ResultsGridWidthHidden.Value), UnitType.Pixel); } catch (Exception e2) { ShowPageMessage("Sort Error " + e2.Message + ", " + e2.ToString(), 2); } }
private void RunReport(String ReportName) { try { if (ReportName.Length != 0) { String sql = string.Empty; using (SqlConnection conn = DB.dbConn()) { conn.Open(); using (IDataReader rs = DB.GetRS("Select * from CustomReport with (NOLOCK) where lower(name)=" + DB.SQuote(ReportName.ToLowerInvariant()), conn)) { if (rs.Read()) { ResultsPanel.Visible = true; sql = DB.RSField(rs, "SQLCommand"); } } } using (SqlConnection conn = DB.dbConn()) { conn.Open(); using (IDataReader rs = DB.GetRS(sql, conn)) { using (DataTable dt = new DataTable()) { dt.Load(rs); ResultsGrid.DataSource = dt; ResultsGrid.DataBind(); } } } } else { ResultsPanel.Visible = false; } } catch (Exception ex) { ltError.Text = CommonLogic.GetExceptionDetail(ex, "<br/>"); } }
protected void SubmitButton_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("Employee Name"); dt.Columns.Add("Variations Found"); dt.Columns.Add("Occurrences"); foreach (Employee employee in employeeList) { DataRow row = dt.NewRow(); int occurences = patternChecker.MatchPatterns(employee, InputText.Value); row[0] = employee.ToString(); row[1] = employee.GetVariations(); row[2] = occurences; dt.Rows.Add(row); } ResultsGrid.DataSource = dt; ResultsGrid.DataBind(); }