private void GoBtn_Click(object sender, EventArgs e) { string start = StartDateBox.Text; string end = EndDateBox.Text; string user = Environment.UserName; DataTable xlReader = XLant.XLSQL.ReturnTable("EXECUTE [XLant].[dbo].[ActionsLog] @user = '******' ,@start = '" + start + "',@end = '" + end + "'"); ResultsGrid.DataSource = xlReader; ResultsGrid.Columns[0].ReadOnly = true; ResultsGrid.Columns[1].ReadOnly = true; ResultsGrid.Columns[3].ReadOnly = true; DataGridViewTextBoxColumn hoursColumn = new DataGridViewTextBoxColumn(); hoursColumn.HeaderText = "Hours"; hoursColumn.ReadOnly = false; hoursColumn.ValueType = typeof(decimal); ResultsGrid.Columns.Add(hoursColumn); ResultsGrid.Columns.Add(CreateSelectColumn("Service")); ResultsGrid.Columns.Add(CreateSelectColumn("Analysis")); ResultsGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; ResultsGrid.MultiSelect = true; ResultsGrid.SelectionMode = DataGridViewSelectionMode.FullRowSelect; ResultsGrid.Update(); }
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); } }
public MainWindow() { InitializeComponent(); StepsGrid.ConfigureSingleClickEditing(); ResultsGrid.DisableSelection(); }
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/>"); } }
private void PrintResults(object sender, RoutedEventArgs e) { if (FoundResults != null) { System.Windows.Controls.PrintDialog dialog = new System.Windows.Controls.PrintDialog(); if (dialog.ShowDialog().Value) { Size pageSize = new Size(dialog.PrintableAreaWidth, dialog.PrintableAreaWidth); ResultsGrid.Arrange(new Rect(5, 5, pageSize.Width * 3, pageSize.Height)); dialog.PrintVisual(ResultsGrid, $"Found {Service.ToString()} services for postcode {Postcode}"); } } else { MessageBox.Show("Nothing to print"); } }
private void Execute() { //get the selected text or the entire box. trim the text var sql = QueryText.SelectedText.Length > 0 ? QueryText.SelectedText.Trim() : QueryText.Text.Trim(); var tokens = new[] { "update", "insert", "delete" }; //not trying to reinvent ssms, just execute a unidata query without msaccess //check if the command starts with one of the tokens //obviously not full-proof var isExecute = tokens.Any(t => sql.StartsWith(t, StringComparison.InvariantCultureIgnoreCase)); try { if (isExecute) { this.Connection.DataConnection.Execute(sql); } else { var t = this.Connection.DataConnection.QueryDataTable(sql); ResultsGrid.ApplyDataTale(t); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } //apply datatable to datagrid //show messages //show execution time? this.Connection.DataConnection.CommandExecuted += DataConnection_CommandExecuted; }
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(); }
private void CreateColumns(Strategy strategy) { var id = 0; if (ShowProgress) { var progressColumn = (DataGridTextColumn)ResultsGrid.AddTextColumn("Progress", LocalizedStrings.Str1570); progressColumn.Binding.StringFormat = "{0}%"; } if (ShowProgress) { ResultsGrid.AddTextColumn("Strategy.Name", LocalizedStrings.NameKey); } foreach (var strategyParam in strategy.Parameters) { var type = strategyParam.Value.GetType(); if (type.IsNumeric() && !type.IsEnum() && !ExcludeParameters.Contains(strategyParam.Name)) { ResultsGrid.AddTextColumn("Parameters[{0}].Value".Put(id), strategyParam.Name); } id++; } id = 0; foreach (var statisticParam in strategy.StatisticManager.Parameters) { var column = (DataGridTextColumn)ResultsGrid.AddTextColumn("Statistics[{0}].Value".Put(id++), statisticParam.DisplayName); var valueType = statisticParam.Value.GetType(); if (valueType.IsNumeric()) { column.Binding.StringFormat = "{0:0.##}"; } } }