private void RefreshDefinition() { filterManager = null; filterManager = new DgvFilterManager(); alarm_definition = m_ds.GetAlarmDefinition(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.DataSource = new DataTable(); dataGridView1.DataSource = alarm_definition; dataGridView1.Columns["id"].ReadOnly = true;//.Visible = false; DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn(); c.DataSource = alarm_definition; c.Name = alarm_definition.listColumn.ColumnName; c.ValueMember = "list"; c.DisplayMember = "list"; c.DataSource = m_ds.GetList(); c.DataPropertyName = "list"; dataGridView1.Columns["list"].Visible = false; dataGridView1.Columns.Insert(1, c); filterManager.DataGridView = dataGridView1; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; }
public Form1(string[] args) { InitializeComponent(); this.Icon = Properties.Resources.Ryder25; LNG = new DataSet("language"); fRF = new FindAndReplaceForm(this.lngDataGridView); filePath = openFileDialog.FileName; lngDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; lngDataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCells; lngDataGridView.DefaultCellStyle.WrapMode = DataGridViewTriState.True; lngDataGridView.AllowUserToAddRows = false; lngDataGridView.AlternatingRowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#E8EDFF"); DgvFilterManager dgvfm = new DgvFilterManager(lngDataGridView); // Open With if (args.Length > 0) { if (File.Exists(args[0]) == true) { filePath = args[0]; Stream s = File.Open(filePath, FileMode.Open, FileAccess.Read, FileShare.Read); lngFile = new LngFile(s); lngDataGridView.DataSource = lngFile.GetDataTable(); this.Text = "Ego Language Editor - " + filePath; } } }
private void Fill() { DocumentPaymentsLogic payments = new DocumentPaymentsLogic(manager); DataGV.AutoGenerateColumns = false; ListToDataTable listToDataTable = new ListToDataTable(); List <ViewPayment> paymentsList = new List <ViewPayment>(); if (documentId == null) { paymentsList = payments.GetAllViewByPeriod(StartDateDTP.Value, EndDateDTP.Value); } else { paymentsList = payments.GetAllViewByDocumentID(Convert.ToInt32(documentId)); StartDateDTP.Enabled = false; EndDateDTP.Enabled = false; } DataGV.DataSource = listToDataTable.ToDataTable <ViewPayment>(paymentsList); DgvFilterManager filterManager = new DgvFilterManager(DataGV); DataGV.Update(); SummaryDataGV.AutoGenerateColumns = true; var groupResult = from p in paymentsList group p by new { p.FullEmployeeName, p.PaymentTypeName } into myGroup where myGroup.Count() > 0 select new { myGroup.Key.FullEmployeeName, myGroup.Key.PaymentTypeName, Count = myGroup.Count(), Suma = myGroup.Sum(a => a.Suma) }; SummaryDataGV.DataSource = groupResult.ToList(); SummaryDataGV.Update(); }
private void btnConnectQc_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; dgvALM.AutoGenerateColumns = false; dtALMTestDetails = BuildDataTable(); treeViewALM.Nodes.Clear(); progressBar1.Value = 0; btnConnectALM.Enabled = false; if (conn == null) { connectToQC(); } if (conn != null) { if (conn.Connected) { showTestLabTree(); } else { MessageBox.Show("QC Connection Failed!"); } } btnConnectALM.Enabled = true; DgvFilterManager filterManager = new DgvFilterManager(dgvALM, true); Cursor.Current = Cursors.Default; }
private void frmOtherWorks_Shown(object sender, EventArgs e) { StagesFilterManager = new DgvFilterManager(dgvStages, true); SetsFilterManager = new DgvFilterManager(dgvSets, true); OtherWorksFilterManager = new DgvFilterManager(dgvOtherWorks, true); dgvStages.ClearSelection(); }
public FormSAPDataTable() { InitializeComponent(); DgvFilterManager fm = new DgvFilterManager(); fm.ColumnFilterAdding += fm_ColumnFilterAdding; fm.DataGridView = dataGridView1; this.Shown += FormSAPDataTable_Shown; }
void fm_PopupShowing(object sender, ColumnFilterEventArgs e) { DgvFilterManager fm = ((DgvFilterManager)sender); Rectangle HeaderRectangle = fm.DataGridView.GetCellDisplayRectangle(e.Column.Index, -1, true); //Show the popup under the column header fm.FilterHost.Popup.Show(fm.DataGridView, HeaderRectangle.Left, HeaderRectangle.Bottom); e.Handled = true; }
private void RefreshLog() { filterManager = null; filterManager = new DgvFilterManager(); int minutes = Convert.ToInt32(this.textBoxDaysBack.Text) * 1440; this.dataGridView1.DataSource = m_ds.GetLog(minutes); filterManager.DataGridView = dataGridView1; }
private void Sample4_Load(object sender, EventArgs e) { InitGrid(); DgvFilterManager fm = new DgvFilterManager(); fm.FilterHost = new CustomizedFilterHost(); fm.DataGridView = dataGridView1; // Customize the popup positioning. fm.PopupShowing += new ColumnFilterEventHandler(fm_PopupShowing); }
private void FillDataGV() { Compas.Logic.Config.ConfigurationParametersLogic configurationsLogic = new ConfigurationParametersLogic(manager); ListToDataTable listToDataTable = new ListToDataTable(); DataGV.AutoGenerateColumns = false; DataGV.DataSource = listToDataTable.ToDataTable <ViewConfigurationParameter>(configurationsLogic.GetAllView()); DgvFilterManager filterManager = new DgvFilterManager(DataGV); DataGV.Update(); }
private void Fill() { CWCarsLogic cars = new CWCarsLogic(manager); DataGV.AutoGenerateColumns = false; ListToDataTable listToDataTable = new ListToDataTable(); DataGV.DataSource = listToDataTable.ToDataTable <CWCarView>(cars.GetAllView().ToList()); DgvFilterManager filterManager = new DgvFilterManager(DataGV); }
public frmNoApproveSets(List <clUser> users) { InitializeComponent(); CreateDtUsers(); CreateDgvUsers(); FillDtUsers(users); dgvChangeDepartmentUser.DataSource = _dtUsers; UsersFilterManager = new DgvFilterManager(dgvChangeDepartmentUser); }
public FormReadTable() { InitializeComponent(); this.readTableControl1.EventMessage += readTableControl1_EventMessage; this.readTableControl1.EventGetTable += readTableControl1_EventGetTable; DgvFilterManager fm = new DgvFilterManager(); fm.ColumnFilterAdding += fm_ColumnFilterAdding; fm.DataGridView = dataGridView1; this.textboxLog.KeyDown += textboxLog_KeyDown; }
private void Sample5_Load(object sender, EventArgs e) { // Use this static property to set your culture-specific months naming. Default is full-named english months DgvMonthYearColumnFilter.MonthCsvList = "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec"; DgvFilterManager fm = new DgvFilterManager(dataGridView1); InitGrid(); fm["CustomerId"] = new CustomizedColumnFilter(); fm["RequiredDate"] = new DgvDateRangeColumnFilter(); fm["OrderId"] = new DgvNumRangeColumnFilter(); fm["OrderDate"] = new DgvMonthYearColumnFilter(); ((DgvMonthYearColumnFilter)fm["OrderDate"]).YearMin = 2007; }
private void MainForm_Load(object sender, System.EventArgs e) { nameTA.Fill(this.dbDataSet.name); DgvFilterManager filterManager = new DgvFilterManager(dataGridView1); dgv.SetGroupOn("phone"); outlookGrid1.BindData(dbDataSet,"name"); outlookGrid1.GroupTemplate = new OutlookGridAlphabeticGroup(); outlookGrid1.GroupTemplate.Column = phoneDataGridViewTextBoxColumn; outlookGrid1.GroupTemplate.Collapsed = true; //used custom datarowcomparer outlookGrid1.Sort(new DataRowComparer(4,ListSortDirection.Ascending)); }
public ImportNrcsSnotel() { InitializeComponent(); filterManager = new DgvFilterManager(); var tbl = NrcsSnotelSeries.SnotelSites; dataGridView1.DataSource = null; this.dataGridView1.DataSource = tbl; this.dataGridView1.SelectionChanged += new EventHandler(dataGridView1_SelectionChanged); dataGridView1.DataError += dataGridView1_DataError; filterManager.DataGridView = dataGridView1; buttonOk.Enabled = false; }
private void Fill() { CardsLogic cardsLogic = new CardsLogic(manager); DataGV.AutoGenerateColumns = false; List <CardView> view = cardsLogic.GetAll().Select(a => new CardView(a)).ToList(); ListToDataTable listToDataTable = new ListToDataTable(); DataGV.DataSource = listToDataTable.ToDataTable <CardView>(view); DgvFilterManager filterManager = new DgvFilterManager(DataGV); DataGV.Update(); }
private void Sample3_Load(object sender, EventArgs e) { InitGrid(); DgvFilterManager fm = new DgvFilterManager(); // Using the ColumnFilterAdding event, you may force your preferred filter, // BEFORE the FilterManager create the predefined filter. This event is // raised for each column in the grid when you set the DataGridView property // of the FilterManager. fm.ColumnFilterAdding += new ColumnFilterEventHandler(fm_ColumnFilterAdding); fm.DataGridView = dataGridView1; // this raises ColumnFilterAdding events // After column filters creation however, you can overwrite the created filter. fm["CustomerID"] = new DgvComboBoxColumnFilter(); }
/// <summary> /// Loads table of equations from the database. /// </summary> private void LoadTable() { filterManager = new DgvFilterManager(); tbl = Database.DB().GetSeriesCatalog("Provider ='CalculationSeries'"); this.dataGridView1.DataSource = new DataTable(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; this.dataGridView1.DataSource = tbl; var cols = this.dataGridView1.Columns; var visible = new string[] { "Units", "TimeInterval", "Name", "TableName", "Expression" }; for (int i = 0; i < cols.Count; i++) { cols[i].Visible = Array.IndexOf(visible, cols[i].Name) >= 0; } dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; filterManager.DataGridView = dataGridView1; }
private void Sample2_Load(object sender, EventArgs e) { InitGrid(); DgvFilterManager fm = new DgvFilterManager(); fm.DataGridView = dataGridView1; //after this line, column filters are created // Get the created column filter for OrderDate column OrderDate = ((DgvDateColumnFilter)fm["OrderDate"]); //Add some new operators OrderDate.ComboBoxOperator.Items.Insert(0, "This year"); OrderDate.ComboBoxOperator.Items.Insert(1, "1 year ago"); OrderDate.ComboBoxOperator.Items.Insert(2, "2 years ago"); //Change the size to accomodate the length of the new operators OrderDate.ComboBoxOperator.Width += 30; OrderDate.DateTimePickerValue.Width -= 30; OrderDate.DateTimePickerValue.Location = new Point(OrderDate.DateTimePickerValue.Left + 30, OrderDate.DateTimePickerValue.Top); OrderDate.FilterExpressionBuilding += new CancelEventHandler(OrderDate_FilterExpressionBuilding); }
private void LoadData() { filterManager = null; filterManager = new DgvFilterManager(); table = null; string tableName = ""; try { tableName = this.comboBoxTableNames.Text; table = m_server.Table(m_server.PortableTableName(tableName)); this.dataGrid1.DataSource = table; this.dataGrid1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; //this.dataGrid1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; filterManager.DataGridView = this.dataGrid1; } catch (Exception ex) { Logger.WriteLine(ex.Message); MessageBox.Show(ex.Message); } }
private void btnConnectJenkins_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; username = txtUserName.Text; password = txtPasswpord.Text; btnConnectJenkins.Enabled = false; dgvJenkins.AutoGenerateColumns = false; progressBar2.Value = 0; joblist = new List <string>(); JenkinServers = new Dictionary <string, List <string> >(); spreadsheetsService = new SpreadsheetsService("AlmJenkinsIntegration"); if (txtUserName.Text.Contains("ngahr")) { //oAuth2(); NGAMail(); } else { oAuth2(); //spreadsheetsService.setUserCredentials(txtUserName.Text, txtPasswpord.Text); } //Passing Spreadsheet Name SpreadsheetQuery spreadsheetQuery = new SpreadsheetQuery(); spreadsheetQuery.Title = txtSpreadSheetName.Text; spreadsheetFeed = spreadsheetsService.Query(spreadsheetQuery); if (spreadsheetFeed.Entries.Count != 1) { MessageBox.Show("Invallid Spreadsheet Name!"); btnConnectJenkins.Enabled = true; return; } AtomLink link = spreadsheetFeed.Entries[0].Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null); WorksheetQuery worksheetQuery = new WorksheetQuery(link.HRef.ToString()); //Passing Worksheet Name worksheetQuery.Title = txtWorkSheetName.Text; worksheetFeed = spreadsheetsService.Query(worksheetQuery); if (worksheetFeed.Entries.Count != 1) { MessageBox.Show("Invallid Worksheet Name!"); btnConnectJenkins.Enabled = true; return; } UpdateListFeed(); // define the table's schema dtJenkinsTestDetails = new DataTable(); dtJenkinsTestDetails.Columns.Add(new DataColumn("TestName", typeof(string))); dtJenkinsTestDetails.Columns.Add(new DataColumn("Result", typeof(string))); dtJenkinsTestDetails.Columns.Add(new DataColumn("JenkinsLog", typeof(string))); dtJenkinsTestDetails.Columns.Add(new DataColumn("ALM", typeof(string))); foreach (ListEntry worksheetRow in listFeed.Entries) { string serverName = worksheetRow.Elements[0].Value.ToString(); if (serverName != string.Empty && serverName.ToLower() != "server" && !JenkinServers.ContainsKey(serverName)) { JenkinServers.Add(serverName, GetInnerJobs(serverName, listFeed.Entries)); } DataRow dr = dtJenkinsTestDetails.NewRow(); dr["TestName"] = worksheetRow.Elements[3].Value.ToString(); dr["Result"] = worksheetRow.Elements[4].Value.ToString(); dr["JenkinsLog"] = worksheetRow.Elements[6].Value.ToString(); dr["ALM"] = worksheetRow.Elements[7].Value.ToString(); dtJenkinsTestDetails.Rows.Add(dr); } progressBar2.Maximum = JenkinServers.Count; progressBar2.PerformStep(); BuildJenkinsTree(); dgvJenkins.DataSource = dtJenkinsTestDetails; lblTestsCount.Text = dtJenkinsTestDetails.Rows.Count.ToString(); lblJobTitle.Text = string.Empty; DgvFilterManager filterManager = new DgvFilterManager(dgvJenkins, true); btnConnectJenkins.Enabled = true; Cursor.Current = Cursors.Default; }
private void SetupGridViewFilter() { filterManager = new DgvFilterManager(dgvData); }
private void toolStripButtonRefresh_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; Application.DoEvents(); filterManager = null; filterManager = new DgvFilterManager(); m_viewTable = Server.Table(baseTableName + "x", this.sqlView); m_table = Server.Table(baseTableName, "select * from " + baseTableName + " where 2 = 1"); m_viewTable.TableNewRow += m_viewTable_TableNewRow; //var col = m_viewTable.Columns[0]; //col.AllowDBNull = false; //col.AutoIncrement = true; //col.AutoIncrementSeed = -999; //col.AutoIncrementStep = 1; this.dataGridView1.DataSource = null; this.dataGridView1.Columns.Clear(); if (LinkLabelPrimaryKey) { var lc = new DataGridViewLinkColumn(); lc.DataPropertyName = m_table.Columns[0].ColumnName; this.dataGridView1.Columns.Add(lc); } this.dataGridView1.DataSource = m_viewTable; this.dataGridView1.DataError += dataGridView1_DataError; // Make referenced columns readonly dataGridView1.Columns[0].ReadOnly = true; // primary key for (int i = 1; i < m_viewTable.Columns.Count; i++) { string colName = m_viewTable.Columns[i].ColumnName; if (m_table.Columns.IndexOf(colName) < 0) { dataGridView1.Columns[colName].ReadOnly = true; } else { dataGridView1.Columns[colName].ReadOnly = false; } } for (int i = 0; i < comboBoxTableNames.Count; i++) { var tbl = Server.Table(baseTableName, "select " + valueMembers[i] + ", " + displayMembers[i] + " from " + comboBoxTableNames[i]); DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn(); c.DataSource = tbl; c.Name = displayMembers[i]; c.DataPropertyName = SourceValueName(i); c.ValueMember = SourceValueName(i); c.DisplayMember = displayMembers[i]; //DataGridViewTextBoxColumn tc = new DataGridViewTextBoxColumn(); if (hideMemberValues[i]) { dataGridView1.Columns[SourceValueName(i)].Visible = false; } this.dataGridView1.Columns.Insert(columnIndexes[i], c); //m_table.Columns.Add("s" + displayMembers[i]); } filterManager.DataGridView = dataGridView1; } finally { Cursor = Cursors.Default; } }
private void Fill(string columnName) { DateTime start = DateTime.Now; WaresLogic wares = new WaresLogic(manager); DataGV.AutoGenerateColumns = false; int?categoryId = null; int?manufacturerId = null; int?unitId = null; //string name = wareFilterUC1.WareName; if (categoriesFilterUC1.SelectedCategoryID >= 0) { categoryId = categoriesFilterUC1.SelectedCategoryID; } //manufacturerId = wareFilterUC1.ManufacturerID; //unitId = wareFilterUC1.UnitID; BindingSource bs = new BindingSource(); var waresList = wares.GetAllView("", categoryId, manufacturerId, unitId); // .Select(a => new //{ // a.ID, // Name = a.Name, // UnitName = a.WareUnit != null ? a.WareUnit.Name : "", // ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "", // CategoryName = a.WareCategory != null ? a.WareCategory.Name : "", // CategoryID = a.CategoryID, // SecondaryUnitID = a.SecondaryUnitID != null ? a.SecondaryUnitID : null, // SecondaryUnitName = a.WareUnit1 != null ? a.WareUnit1.Name : "", // SecondaryUnitQuantity = a.SecondaryUnitQuantity != null ? a.SecondaryUnitQuantity : null, // a.WareCodes, // a.WareTimeLimits //});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList(); //List<WareView> viewList = new List<WareView>(); DateTime start0 = DateTime.Now; //foreach (var a in waresList) //{ // WareView wv = new WareView(); // wv.ID = a.ID; // wv.CategoryID = a.CategoryID; // wv.Name = a.Name; // wv.CategoryName = a.CategoryName; // wv.ManufacturerName = a.ManufacturerName; // wv.UnitName = a.UnitName; // wv.SecondaryUnitID = a.SecondaryUnitID; // wv.SecondaryUnitName = a.SecondaryUnitName; // wv.SecondaryUnitQuantity = a.SecondaryUnitQuantity; // //wv.WareCodes = a.WareCodes.ToList(); // //var lastTimeLimit = (from aa in a.WareTimeLimits // // where aa.Active == true // // select aa).FirstOrDefault(); // //if (lastTimeLimit != null) // // wv.TimeLimit = lastTimeLimit.TimeLimit; // //else // // wv.TimeLimit = 0; // viewList.Add(wv); //} DateTime start1 = DateTime.Now; //BindingListView<WareView> view = new BindingListView<WareView>(viewList); //bs.DataSource = view; //bs.Sort = columnName; view = new SortableBindingList <ViewWare>(waresList); ListToDataTable listToDataTable = new ListToDataTable(); DataGV.DataSource = listToDataTable.ToDataTable <ViewWare>(waresList); //DataGV.DataSource = view; DataGV.Update(); DgvFilterManager filterManager = new DgvFilterManager(DataGV); DateTime start2 = DateTime.Now; //MessageBox.Show(start.ToString() + " " + start0.ToString() + " " + start1.ToString() + " " + start2.ToString()); }