private void lnkLbClearFilter_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { try { lnkLbClearFilter.Visible = false; DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvDeliveryMaster); bsDelivery.DataSource = dtDeliveryMaster; dgvDeliveryMaster.DataSource = bsDelivery; } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } }
private void DataGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { string filterStatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dataGridView); if (string.IsNullOrEmpty(filterStatus)) { ShowAllLabel.Visible = false; FilterStatusLabel.Visible = false; } else { ShowAllLabel.Visible = true; FilterStatusLabel.Visible = true; FilterStatusLabel.Text = filterStatus; } }
void dgvbindingcomplete(object sender, DataGridViewBindingCompleteEventArgs e) { string filterstatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dgv); if (string.IsNullOrEmpty(filterstatus)) { ssl1.Visible = false; ssl2.Visible = false; } else { ssl1.Visible = true; ssl2.Visible = true; ssl2.Text = filterstatus; } }
protected void ShowFilterStatus() { string filterStatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dataGridView); // set labels when not filtered if (string.IsNullOrEmpty(filterStatus) && AllRowsAreVisible) { ShowLabelsWhenNotFiltered(); } // set labels when filtered else { ShowLabelsWhenFiltered(); filterStatusLabel.Text = filterStatus; } }
private void dataGridViewPackageBackup_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { String filterStatus = DataGridViewAutoFilterColumnHeaderCell .GetFilterStatus(dataGridViewPackageBackup); if (String.IsNullOrEmpty(filterStatus)) { showAllLabelH.Visible = false; fiterStatusLabelH.Visible = false; } else { showAllLabelH.Visible = true; fiterStatusLabelH.Visible = true; fiterStatusLabelH.Text = filterStatus; } }
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { // Continue only if the data source has been set. String filterStatus = DataGridViewAutoFilterColumnHeaderCell .GetFilterStatus(dataGridView1); if (String.IsNullOrEmpty(filterStatus)) { showAllLabel.Visible = false; filterStatusLabel.Visible = false; } else { showAllLabel.Visible = true; filterStatusLabel.Visible = true; filterStatusLabel.Text = filterStatus; } }
// Updates the filter status label. private void dgvOrders_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { String filterStatus = DataGridViewAutoFilterColumnHeaderCell .GetFilterStatus(dgvExpenseCodes); if (String.IsNullOrEmpty(filterStatus)) { showAllLabel.Visible = false; filterStatusLabel.Visible = false; } else { showAllLabel.Visible = true; filterStatusLabel.Visible = true; filterStatusLabel.Text = filterStatus; } }
private void dgvConfiguration_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { String filterStatus = DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dgvConfiguration); if (String.IsNullOrEmpty(filterStatus)) { lnkShowAllConfiguration.Visible = false; lblFilterConfigurationStatus.Visible = false; } else { lnkShowAllConfiguration.Visible = true; lblFilterConfigurationStatus.Visible = true; lblFilterConfigurationStatus.Text = filterStatus; } foreach (DataGridViewColumn col in dgvConfiguration.Columns) { col.HeaderCell.Tag = col.Width / 2 <= 0 ? col.Width : col.Width / 2; } }
/// <summary> /// Clear filter on data grid view - shows all records. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void lnklblClearFilter_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { try { // lnklblClearFilter.Visible = false; DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvTasks); //bsTansList.DataSource = ShipmentTANs; //dgvShipmentTANs.DataSource = bsTansList; if (HeaderCheckBox.Checked) { HeaderCheckBox.Checked = false; } } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } }
/// <summary> /// Removes the filter from the BindingSource bound to the specified DataGridView. /// </summary> /// <param name="dataGridView">The DataGridView bound to the BindingSource to unfilter.</param> public static void RemoveFilter(DataGridView dataGridView) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dataGridView); }
private void toolStripStatus_ShowAll_Click(object sender, EventArgs e) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(this.dataGridView1); }
private void toolStripButton6_Click(object sender, EventArgs e) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(gv_taskmanager); }
private void tsbRemoveFilter_Click(object sender, EventArgs e) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvUserProjectGroups); }
/// <summary> /// Формированре масива /// значений для графика функции /// для всех значений /// </summary> /// <param name="nameCol">имя столбца</param> private void sampleValues(string nameCol) { string strQuery = string.Empty; int countList = -1; string elem; ////??? без таблицы, использовать m_dictValues //var enValues = (from r in m_tblEdit.AsEnumerable() // where r.Field<string>("N_ALG") == m_nameAlg // select new // { // nameCol = r.Field<float>(nameCol), // }).Distinct(); if (!(nameCol == "A3")) { //countList = enValues.Count(); //pointList = new PointPairList[countList]; //for (int i = 0; i < enValues.Count(); i++) //{ // elem = enValues.ElementAt(i).nameCol.ToString().Replace(",", "."); // strQuery = " N_ALG = " + "'" + m_nameAlg + "'and " + nameCol + " = " + elem + ""; // ftTableF = m_tblEdit.Select(strQuery); // createPointLists(i, ftTableF); //} } else { //var enValuesA2 = (from r in m_tblEdit.AsEnumerable() // where r.Field<string>("N_ALG") == m_nameAlg // select new // { // nameCol = r.Field<float>("A2"), // }).Distinct(); //countList = enValues.Count() * enValuesA2.Count(); pointList = new PointPairList[countList]; int num = 0; string m_ftValue = DataGridViewAutoFilterColumnHeaderCell.FilterValue(); elem = m_ftValue.ToString().Replace(",", "."); //for (int i = 0; i < enValuesA2.Count(); i++) //{ // strQuery = " N_ALG = " + "'" + m_nameAlg + "' and " + nameCol + " = " + elem + " and A2= " + enValuesA2.ElementAt(i).nameCol.ToString().Replace(",", ".") + ""; // //??? без таблицы, использовать m_dictValues // //ftTableF = m_tblEdit.Select(strQuery); // //if (!(ftTableF.Count() == 0)) // //{ // // createPointLists(num, ftTableF); // // num++; // //} // //else // // ; //} } createGraphs(); }
private void lnkShowAllConfiguration_Click(object sender, EventArgs e) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvConfiguration); }
/// <summary> /// Gets a status string for the specified DataGridView indicating the /// number of visible rows in the bound, filtered BindingSource, or /// String.Empty if all rows are currently visible. /// </summary> /// <param name="dataGridView">The DataGridView bound to the /// BindingSource to return the filter status for.</param> /// <returns>A string in the format "x of y records found" where x is /// the number of rows currently displayed and y is the number of rows /// available, or String.Empty if all rows are currently displayed.</returns> public static String GetFilterStatus(DataGridView dataGridView) { return(DataGridViewAutoFilterColumnHeaderCell.GetFilterStatus(dataGridView)); }
void remclick(object sender, EventArgs e) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgv); }
// Clears the filter when the user clicks the "Show All" link // or presses ALT+A. private void showAllLabel_Click(object sender, EventArgs e) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dataGridView1); }
private void lnkShowAllSource_Click(object sender, EventArgs e) { DataGridViewAutoFilterColumnHeaderCell.RemoveFilter(dgvSource); }