pivot #1

New Issue

mjjo · 2017-08-07T07:04:40Z

mjjo commented

2017-08-07 07:04:40 +00:00

void Pivot()
{
    DataTable data = GetDataTableFromDGV(dataGridView1);

    dataGridView1.Rows.Clear();
    dataGridView1.Columns.Clear();

    int iColSize = data.Columns.Count;
    int iRowSize = data.Rows.Count - 1;

    for (int i = 0; i < iRowSize; i++)
        dataGridView1.Columns.Add("", "");

    for (int iCol = 0; iCol < iColSize; iCol++)
    {
        int iRowIdx = dataGridView1.Rows.Add();
        for (int iRow = 0; iRow < iRowSize; iRow++)
            dataGridView1.Rows[iRowIdx].Cells[iRow].Value = data.Rows[iRow][iCol];
    }

    for (int i = 0; i < iRowSize; i++)
        dataGridView1.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}

``` void Pivot() { DataTable data = GetDataTableFromDGV(dataGridView1); dataGridView1.Rows.Clear(); dataGridView1.Columns.Clear(); int iColSize = data.Columns.Count; int iRowSize = data.Rows.Count - 1; for (int i = 0; i < iRowSize; i++) dataGridView1.Columns.Add("", ""); for (int iCol = 0; iCol < iColSize; iCol++) { int iRowIdx = dataGridView1.Rows.Add(); for (int iRow = 0; iRow < iRowSize; iRow++) dataGridView1.Rows[iRowIdx].Cells[iRow].Value = data.Rows[iRow][iCol]; } for (int i = 0; i < iRowSize; i++) dataGridView1.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } ```

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Reference: work/friction#1