internal DataGridViewColumnCollectionDialog(IServiceProvider provider)
{
this.serviceProvider = provider;
this.InitializeComponent();
this.dataGridViewPrivateCopy = new DataGridView();
this.columnsPrivateCopy = this.dataGridViewPrivateCopy.Columns;
this.columnsPrivateCopy.CollectionChanged += new CollectionChangeEventHandler(this.columnsPrivateCopy_CollectionChanged);
}
public void LoadCbListColumnsToFilter(System.Windows.Forms.DataGridViewColumnCollection columns, DataGridView datagrid)
{
if (columns != null)
{
for (int i = 0; i < columns.Count; i++)
{
cb_FiltreDgEducation_Formations.Items.Add(columns[i].HeaderText);
}
}
}
public DGVOptions(DataTable dataTable, DataGridViewColumnCollection columnCollection)
{
InitializeComponent();
IEnumerable<object> existingColumns =
columnCollection.Cast<DataGridViewColumn>().Select(x => (object) x.Name);
IEnumerable<object> availiableColumns =
dataTable.Columns.Cast<DataColumn>().Select(x => (object) x.ColumnName);
listBox1.Items.AddRange(availiableColumns.Except(existingColumns).ToArray());
listBox2.Items.AddRange(existingColumns.ToArray());
}
private bool ContainsColumn(DataGridViewColumnCollection collection, string bindingField)
{
foreach (DataGridViewColumn column in collection)
{
if (string.Compare(column.DataPropertyName, bindingField, StringComparison.OrdinalIgnoreCase) == 0)
{
return true;
}
}
return false;
}
public frmSelectedColumn(DataGridViewColumnCollection cs)
: this()
{
_columns = cs;
lvColumns.Items.Clear();
foreach (DataGridViewColumn item in _columns)
{
ListViewItem lvi = new ListViewItem(Languages.Language.GetString(item.HeaderText));
lvi.Tag = item.Name;
lvColumns.Items.Add(lvi);
}
}
public EditForm(string Label, DataRow item, DataGridViewColumnCollection columns, OleDbConnection conn)
{
InitializeComponent();
this.dataGridViewHeight = dataGridView.Height;
this.dataSet = new DataSet();
this.Text = Label;
this.item = item;
//todo: remove
this.columns = columns;
this.dataTable = item.Table;
this.conn = conn;
}
/// <summary>
/// 返回指定列名的索引位置
/// </summary>
public static int IndexOfHeader(System.Windows.Forms.DataGridViewColumnCollection dgvcs, string ColHeaderName)
{
int idx = -1;
for (int i = 0; i < dgvcs.Count; i++)
{
if (dgvcs[i].HeaderText == ColHeaderName)
{
idx = i;
break;
}
}
return(idx);
}
/// <summary>
/// Initializes a new instance of the <see cref="ExportForm"/> class.
/// </summary>
/// <param name="movieList">The movie list.</param>
/// <param name="cols">The cols.</param>
public ExportForm(List<Movie> movieList, DataGridViewColumnCollection cols)
{
InitializeComponent();
this.DialogResult = DialogResult.Cancel;
this._movies = movieList;
this._cols = cols;
this._export.ExcelExportFinish += new ExcelExport.ExcelExportFinishEventhandler(_export_ExcelExportFinish);
this._export.ExcelExportResponse += new ExcelExport.ExcelExportEventHandler(_export_ExcelExportResponse);
this._InitControls();
}
public DataGridViewAddColumnDialog(DataGridViewColumnCollection dataGridViewColumns, DataGridView liveDataGridView)
{
this.dataGridViewColumns = dataGridViewColumns;
this.liveDataGridView = liveDataGridView;
Font defaultFont = Control.DefaultFont;
IUIService service = (IUIService) this.liveDataGridView.Site.GetService(iUIServiceType);
if (service != null)
{
defaultFont = (Font) service.Styles["DialogFont"];
}
this.Font = defaultFont;
this.InitializeComponent();
this.EnableDataBoundSection();
}
public ColumnSettings(DataGridViewColumnCollection columns)
{
SettingList = new List<ColumnSetting>(columns.Count);
foreach (DataGridViewColumn c in columns)
{
ColumnSetting cs = new ColumnSetting();
cs.DisplayIndex = c.DisplayIndex;
cs.Name = c.Name;
cs.Width = c.Width;
cs.Visible = c.Visible;
SettingList.Add(cs);
}
}
public frmSort(DataGridViewColumnCollection dcl)
{
this.InitializeComponent();
clsMe clsMe = new clsMe();
clsMe.setFormStyl(this);
this.BindCombox1(dcl);
this.BindCombox2(dcl);
this.BindCombox3(dcl);
this.BindCombox4(dcl);
this.comboBox1.SelectedIndex = 0;
this.comboBox2.SelectedIndex = 0;
this.comboBox3.SelectedIndex = 0;
this.comboBox4.SelectedIndex = 0;
this.fillfinishok = true;
}
private void ShowColumns(DataGridViewColumnCollection columns)
{
_checkBoxs.Clear();
foreach (DataGridViewColumn col in columns)
{
CheckBox checkBox = new CheckBox();
checkBox.Dock = DockStyle.Top;
checkBox.Text = col.ToolTipText;
checkBox.Tag = col;
checkBox.Checked = col.Visible;
_checkBoxs.Add(checkBox);
checkBox.CheckedChanged += checkBox_CheckedChanged;
}
_checkBoxs.Reverse();
groupBox1.Controls.AddRange(_checkBoxs.ToArray());
}
public frmView(DataGridViewColumnCollection dcl)
{
this.InitializeComponent();
clsMe clsMe = new clsMe();
clsMe.setFormStyl(this);
for (int i = 0; i < dcl.Count; i++)
{
if (dcl[i].Visible)
{
this.listBox2.Items.Add(dcl[i].HeaderText);
}
else
{
this.listBox1.Items.Add(dcl[i].HeaderText);
}
}
this.listBox2.SelectedIndex = this.listBox2.Items.Count - 1;
if (this.listBox1.Items.Count > 0)
{
this.listBox1.SelectedIndex = this.listBox1.Items.Count - 1;
}
}
public Универсальная_форма(string Окно_имя, DataGridViewColumnCollection Коллекция, DataGridViewRow Строка = null)
{
InitializeComponent();
this.Text = Окно_имя;
Редактирование_строк = Строка;
ед_данных = new List<TextBox>();
for (int i = 0; i < Коллекция.Count; i++)
{
Label Имя_поля = new Label(); //заполнение и размещение списка названий полей
Имя_поля.Text = Коллекция[i].Name;
Имя_поля.Location = new Point(10, 9 + i * 26);//(гориз,верт)
Controls.Add(Имя_поля); //добавление на форму
TextBox Значение = new TextBox(); //(редактирование/ввод новых) и размещение изменяемых значений строк
ед_данных.Add(Значение);
Значение.Location = new Point(110, 6 + i * 26);//(гориз,верт)
Значение.Size = new Size(250, Значение.Size.Height);
Controls.Add(Значение); //добавление на форму
}
//размещаем кнопки
Кн_ОК.Location = new Point(Кн_ОК.Location.X, Коллекция.Count * 26 + 10);//(гориз,верт)
Кн_Отмена.Location = new Point(Кн_Отмена.Location.X, Коллекция.Count * 26 + 10);//(гориз,верт)
if (Строка != null)// Если строка DataGrid не пуста (режим редактирования записи):
{
for (int i = 0; i < Строка.Cells.Count; i++)// Заполняем TextBox-ы значениями
{
ед_данных[i].Text = Строка.Cells[i].Value.ToString();
}
Кн_ОК.Text = "Сохранить"; // И т.к. это режим Редактирования меняем название кнопки
}
}
public void exportDataGridViewToExcel(string titulo, DataGridViewColumnCollection encabezados, DataTable datos, string nombreArchivo)
{
int columna = 1;
int fila = 1;
if (encabezados != null && datos != null)
{
try
{
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
excel.Workbooks.Add(true);
foreach (DataGridViewColumn column in encabezados)
{
excel.Cells[fila, columna] = column.HeaderText;
excel.ActiveCell.Font.Bold = true;
excel.ActiveCell.EntireColumn.NumberFormat = convertFormatExcel(column.DefaultCellStyle.Format);
excel.ActiveCell.get_Offset(0, 1).Activate();
columna++;
}
fila++;
foreach (DataRow row in datos.Rows)
{
columna = 1;
foreach (DataGridViewColumn column in encabezados)
{
if (column.Visible)
{
if (row.Table.Columns.Contains(column.Name))
{
excel.Cells[fila, columna] = row.Field<object>(column.Name);
}
columna++;
}
}
fila++;
}
excel.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR AL GENERAR ARCHIVO EXCEL", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void SetVertical(DataGridView button, DataGridViewColumnCollection col)
{
}
static string XmlFromColumnsProperty(DataGridViewColumnCollection Columns)
{
StringBuilder SB = new StringBuilder();
SB.Append(StartTag(ModUiTags.Columns));
foreach (DataGridViewColumn Column in Columns)
{
SB.Append(XmlFromColumnProperty(Column));
}
SB.Append(EndTag(ModUiTags.Columns));
return SB.ToString();
}
public static bool ValidName(string name, DataGridViewColumnCollection columns, IContainer container, INameCreationService nameCreationService, DataGridViewColumnCollection liveColumns, bool allowDuplicateNameInLiveColumnCollection, out string errorString)
{
if (columns.Contains(name))
{
errorString = System.Design.SR.GetString("DataGridViewDuplicateColumnName", new object[] { name });
return false;
}
if (((container != null) && (container.Components[name] != null)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name)))
{
errorString = System.Design.SR.GetString("DesignerHostDuplicateName", new object[] { name });
return false;
}
if (((nameCreationService != null) && !nameCreationService.IsValidName(name)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name)))
{
errorString = System.Design.SR.GetString("CodeDomDesignerLoaderInvalidIdentifier", new object[] { name });
return false;
}
errorString = string.Empty;
return true;
}
public ColumnsSelector(DataGridViewColumnCollection columns)
: this()
{
ShowColumns(columns);
}
private void RemoveColumn(DataGridViewColumnCollection collection, string bindingField)
{
int rmvIndex = -1;
foreach (DataGridViewColumn column in collection)
{
if (string.Compare(column.DataPropertyName, bindingField, StringComparison.OrdinalIgnoreCase) == 0)
{
rmvIndex = column.Index;
break;
}
}
if (rmvIndex != -1)
{
this.DesignerHost.DestroyComponent(collection[rmvIndex]);
collection.RemoveAt(rmvIndex);
}
}
private void BindCombox1(DataGridViewColumnCollection dcl)
{
List<frmSort.SortCol> list = new List<frmSort.SortCol>();
for (int i = 0; i < dcl.Count; i++)
{
if (dcl[i].Visible)
{
frmSort.SortCol item = new frmSort.SortCol
{
valueMember = dcl[i].Name,
textMember = dcl[i].HeaderText
};
list.Add(item);
}
}
this.comboBox1.DataSource = list;
this.comboBox1.DisplayMember = "textMember";
this.comboBox1.ValueMember = "valueMember";
}
/// <summary>
/// Returns an observable sequence wrapping the CollectionChanged event on the DataGridViewColumnCollection instance.
/// </summary>
/// <param name="instance">The DataGridViewColumnCollection instance to observe.</param>
/// <returns>An observable sequence wrapping the CollectionChanged event on the DataGridViewColumnCollection instance.</returns>
public static IObservable <EventPattern <CollectionChangeEventArgs> > CollectionChangedObservable(this DataGridViewColumnCollection instance)
{
return(Observable.FromEventPattern <CollectionChangeEventHandler, CollectionChangeEventArgs>(
handler => instance.CollectionChanged += handler,
handler => instance.CollectionChanged -= handler));
}
private int dataGridView_indexOf(DataGridViewColumnCollection cols, string colName)
{
int _i = 0;
bool found = false;
for (; _i < cols.Count; _i++)
if (cols[_i].Name == colName) { found = true; break; }
return found ? _i : -1;
}
public frmFilter(DataGridViewColumnCollection dcl)
{
}
private DataGridViewColumnCollection CreateColumn(DataColumnCollection clms,DataGridView grdv)
{
DataGridViewColumnCollection clmsNew = new DataGridViewColumnCollection(grdv);
foreach (DataColumn col in clms)
{
DataGridViewColumn grdcol = new DataGridViewColumn();
grdcol.HeaderText = col.ColumnName;
clmsNew.Add(grdcol);
}
return clmsNew;
}
public static bool ValidName(string name, DataGridViewColumnCollection columns, IContainer container, INameCreationService nameCreationService, DataGridViewColumnCollection liveColumns, bool allowDuplicateNameInLiveColumnCollection)
{
if (columns.Contains(name))
{
return false;
}
if (((container != null) && (container.Components[name] != null)) && ((!allowDuplicateNameInLiveColumnCollection || (liveColumns == null)) || !liveColumns.Contains(name)))
{
return false;
}
return (((nameCreationService == null) || nameCreationService.IsValidName(name)) || ((allowDuplicateNameInLiveColumnCollection && (liveColumns != null)) && liveColumns.Contains(name)));
}
public DataGridView ()
{
SetStyle (ControlStyles.Opaque, true);
//SetStyle (ControlStyles.UserMouse, true);
SetStyle (ControlStyles.OptimizedDoubleBuffer, true);
adjustedTopLeftHeaderBorderStyle = new DataGridViewAdvancedBorderStyle();
adjustedTopLeftHeaderBorderStyle.All = DataGridViewAdvancedCellBorderStyle.Single;
advancedCellBorderStyle = new DataGridViewAdvancedBorderStyle();
advancedCellBorderStyle.All = DataGridViewAdvancedCellBorderStyle.Single;
advancedColumnHeadersBorderStyle = new DataGridViewAdvancedBorderStyle();
advancedColumnHeadersBorderStyle.All = DataGridViewAdvancedCellBorderStyle.Single;
advancedRowHeadersBorderStyle = new DataGridViewAdvancedBorderStyle();
advancedRowHeadersBorderStyle.All = DataGridViewAdvancedCellBorderStyle.Single;
alternatingRowsDefaultCellStyle = new DataGridViewCellStyle();
allowUserToAddRows = true;
allowUserToDeleteRows = true;
allowUserToOrderColumns = false;
allowUserToResizeColumns = true;
allowUserToResizeRows = true;
autoGenerateColumns = true;
autoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
autoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;
backColor = Control.DefaultBackColor;
backgroundColor = SystemColors.AppWorkspace;
borderStyle = BorderStyle.FixedSingle;
cellBorderStyle = DataGridViewCellBorderStyle.Single;
clipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithAutoHeaderText;
columnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
columnHeadersDefaultCellStyle = new DataGridViewCellStyle();
columnHeadersDefaultCellStyle.BackColor = SystemColors.Control;
columnHeadersDefaultCellStyle.ForeColor = SystemColors.WindowText;
columnHeadersDefaultCellStyle.SelectionBackColor = SystemColors.Highlight;
columnHeadersDefaultCellStyle.SelectionForeColor = SystemColors.HighlightText;
columnHeadersDefaultCellStyle.Font = this.Font;
columnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
columnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.True;
columnHeadersHeight = 23;
columnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
columnHeadersVisible = true;
columns = CreateColumnsInstance();
columns.CollectionChanged += OnColumnCollectionChanged;
currentCellAddress = new Point (-1, -1);
dataMember = String.Empty;
defaultCellStyle = new DataGridViewCellStyle();
defaultCellStyle.BackColor = SystemColors.Window;
defaultCellStyle.ForeColor = SystemColors.ControlText;
defaultCellStyle.SelectionBackColor = SystemColors.Highlight;
defaultCellStyle.SelectionForeColor = SystemColors.HighlightText;
defaultCellStyle.Font = this.Font;
defaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
defaultCellStyle.WrapMode = DataGridViewTriState.False;
editMode = DataGridViewEditMode.EditOnKeystrokeOrF2;
firstDisplayedScrollingColumnHiddenWidth = 0;
isCurrentCellDirty = false;
multiSelect = true;
readOnly = false;
rowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
rowHeadersDefaultCellStyle = (DataGridViewCellStyle) columnHeadersDefaultCellStyle.Clone ();
rowHeadersVisible = true;
rowHeadersWidth = 41;
rowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.EnableResizing;
rows = CreateRowsInstance();
rowsDefaultCellStyle = new DataGridViewCellStyle();
selectionMode = DataGridViewSelectionMode.RowHeaderSelect;
showCellErrors = true;
showEditingIcon = true;
scrollBars = ScrollBars.Both;
userSetCursor = Cursor.Current;
virtualMode = false;
horizontalScrollBar = new HScrollBar();
horizontalScrollBar.Scroll += OnHScrollBarScroll;
horizontalScrollBar.Visible = false;
verticalScrollBar = new VScrollBar();
verticalScrollBar.Scroll += OnVScrollBarScroll;
verticalScrollBar.Visible = false;
Controls.AddRange (new Control[] {horizontalScrollBar, verticalScrollBar});
}
private string ColName(DataGridViewColumnCollection cols, string mask)
{
string s = mask == null ? cols[0].Name : mask;
for (int i = 1; i < cols.Count; ++i)
{
s += ", " + (mask == null ? cols[i].Name : mask);
}
return s;
}
