private void InitializeGrid(int rows, int columns) { try { dataGridView1.ColumnCount = columns; dataGridView1.ColumnHeadersVisible = true; DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle(); columnHeaderStyle.BackColor = Color.Beige; columnHeaderStyle.Font = new Font("Times new roman", 12, FontStyle.Bold); dataGridView1.ColumnHeadersDefaultCellStyle = columnHeaderStyle; for (int i = 0; i < columns; i++) { dataGridView1.Columns[i].Name = LetterNumberConverter.NumberToLetter(i); } dataGridView1.RowCount = rows; dataGridView1.RowHeadersVisible = true; DataGridViewCellStyle rowHeaderStyle = new DataGridViewCellStyle(); rowHeaderStyle.BackColor = Color.Beige; rowHeaderStyle.Font = new Font("Times new roman", 12, FontStyle.Bold); dataGridView1.ColumnHeadersDefaultCellStyle = rowHeaderStyle; for (int i = 0; i < rows; i++) { dataGridView1.Rows[i].HeaderCell.Value = (i).ToString(); } for (int i = 0; i < rows; i++) { for (int j = 0; j < columns; j++) { DataCell cell = new DataCell(); cell.name_set(dataGridView1.Columns[j].Name + dataGridView1.Rows[i].HeaderCell.Value); cell.column = j; cell.row = i; Data.DataAdd(cell); } } Data.columns = columns; Data.rows = rows; } catch (Exception) { } }
private void saveToolStripMenuItem_Click(object sender, EventArgs e) { try { Stream mystream; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { if (((mystream = saveFileDialog1.OpenFile()) != null)) { StreamWriter sw = new StreamWriter(mystream); sw.WriteLine(dataGridView1.RowCount); sw.WriteLine(dataGridView1.ColumnCount); for (int i = 0; i < dataGridView1.RowCount; i++) { for (int j = 0; j < dataGridView1.ColumnCount; j++) { if (dataGridView1.Rows[i].Cells[j].Value != null) { sw.WriteLine(dataGridView1.Rows[i].Cells[j].Value.ToString()); } else { sw.WriteLine(""); } } } for (int i = 0; i < dataGridView1.RowCount; i++) { for (int j = 0; j < dataGridView1.ColumnCount; j++) { string cell_name = LetterNumberConverter.NumberToLetter(j + 1) + (i + 1).ToString(); if (Data.GetData(i, j).expression_get() != null) { sw.WriteLine(Data.GetData(i, j).expression_get()); } else { sw.WriteLine(""); } } } sw.Close(); mystream.Close(); } } } catch (Exception) { MessageBox.Show("Saving Error"); } }
public int AddColumn(int _c, DataGridView dgv) { _c++; DataGridViewColumn column = (DataGridViewColumn)dgv.Columns[0].Clone(); column.HeaderCell.Value = LetterNumberConverter.NumberToLetter(_c - 1); dgv.Columns.Add(column); for (int i = 0; i < dataGridView1.RowCount; i++) { DataCell cell = new DataCell(); cell.name_set(dataGridView1.Columns[_c - 1].Name + dataGridView1.Rows[i].HeaderCell.Value); cell.column = _c - 1; cell.row = i; Data.DataAdd(cell); } Data.columns++; return(0); }