how to display datagridview rows as column and columns as rows in another datagridview using datatable I am using this code but its not working Dim dts As New DataTable dtsColumnsAdd34SId34 dtsColumnsAdd34Shift34 dtsColumnsAdd34DDate34 For i 0 To DataGridView1RowsCount 4 For x 0 To DataGridView1ColumnsCount 4 Dim dr As DataRow dtsNewRow dr34SId34 DataGridView1Item0

Hi satabeachPlease refer below sampleCodeCDataTable dt1 new DataTableDataTable dt2 new DataTablepublic Form1 InitializeComponent dt1ColumnsAddRangenew DataColumn new DataColumn34Name34 new DataColumn3401Jan1834 new DataColumn3402Jan1834 new DataColumn3403Jan1834 new DataColumn3404Jan1834 dt1RowsAdd34Ahemd34 34134 34134 34OFF34 34OFF34 dt1RowsAdd34Ajith34 34334 34334 34234 34234 dt1RowsAdd34Soumya34 34OFF34 34134 34134 34134 thisDataGridView1DataSource dt1private void Button1Clickobject sender EventArgs e dt2ColumnsAdd34Name34 dt2ColumnsAdd34Duty34 dt2ColumnsAdd34Date34 for int row 0 row lt dt1RowsCount row for int column 1 column lt dt1ColumnsCount column dt2Row

Convert DataGridView rows as columns in Windows Application

satabeac...

SOLVED CLOSED ACTIVE ANSWERED
User: satabeach
Posted: on Oct 17, 2018 03:34 AM
Forum: Windows Basics
Answer: 1
Views: 3253

how to display datagridview rows as column and columns as rows in another datagridview using datatable

I am using this code but its not working

        Dim dts As New DataTable
        dts.Columns.Add("SId")
        dts.Columns.Add("Shift")
        dts.Columns.Add("DDate")
        For i = 0 To DataGridView1.Rows.Count - 4
            For x = 0 To DataGridView1.Columns.Count - 4
                Dim dr As DataRow = dts.NewRow
                dr("SId") = DataGridView1.Item(0, i).Value.ToString
                dr("DDate") = DataGridView1.Item(2, x).Value.ToString
                'dr("Shift") = DataGridView1.CurrentCell.Value.ToString()
                'dr("DDate") = DataGridView1.Columns(msg).HeaderText.ToString.ToString()
                dts.Rows.Add(dr)
                dts.AcceptChanges()
            Next
        Next
        Me.DataGridView2.DataSource = dts

here is what I want

        Dim dt1 As DataTable = New DataTable()
        dt1.Columns.AddRange(New DataColumn() {New DataColumn("Name"), New DataColumn("01-Jan-18"), New DataColumn("02-Jan-18"), New DataColumn("03-Jan-18"), New DataColumn("04-Jan-18")})
        dt1.Rows.Add("Ahemd", "1", "1", "OFF", "OFF")
        dt1.Rows.Add("Ajith", "3", "3", "2", "2")
        dt1.Rows.Add("Soumya", "OFF", "1", "1", "1")
        Me.DataGridView1.DataSource = dt1
 
        Dim dt2 As DataTable = New DataTable()
        dt2.Columns.Add("Name")
        dt2.Columns.Add("Duty")
        dt2.Columns.Add("Date")
        dt2.Rows.Add("Ahemd", "1", "01-Jan-2018")
        dt2.Rows.Add("Ahemd", "1", "02-Jan-2018")
        dt2.Rows.Add("Ahemd", "OFF", "03-Jan-2018")
        dt2.Rows.Add("Ahemd", "OFF", "04-Jan-2018")
        dt2.Rows.Add("Ajith", "3", "01-Jan-2018")
        dt2.Rows.Add("Ajith", "3", "02-Jan-2018")
        dt2.Rows.Add("Ajith", "2", "03-Jan-2018")
        dt2.Rows.Add("Ajith", "2", "04-Jan-2018")
        dt2.Rows.Add("Soumya", "OFF", "01-Jan-2018")
        dt2.Rows.Add("Soumya", "1", "02-Jan-2018")
        dt2.Rows.Add("Soumya", "2", "03-Jan-2018")
        dt2.Rows.Add("Soumya", "3", "04-Jan-2018")
        Me.DataGridView2.DataSource = dt2

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 3

Reply
ANSWER
User: pandeyism
Replied: on Oct 19, 2018 05:48 AM
Report

Hi satabeach,

Please refer below sample.

Code

DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
public Form1()
{
    InitializeComponent();
    dt1.Columns.AddRange(new DataColumn[] { new DataColumn("Name"), new DataColumn("01-Jan-18"), new DataColumn("02-Jan-18"), new DataColumn("03-Jan-18"), new DataColumn("04-Jan-18") });
    dt1.Rows.Add("Ahemd", "1", "1", "OFF", "OFF");
    dt1.Rows.Add("Ajith", "3", "3", "2", "2");
    dt1.Rows.Add("Soumya", "OFF", "1", "1", "1");
    this.DataGridView1.DataSource = dt1;
}

private void Button1_Click(object sender, EventArgs e)
{
    dt2.Columns.Add("Name");
    dt2.Columns.Add("Duty");
    dt2.Columns.Add("Date");
    for (int row = 0; row < dt1.Rows.Count; row++)
    {
        for (int column = 1; column < dt1.Columns.Count; column++)
        {
            dt2.Rows.Add(dt1.Rows[row][0], dt1.Rows[row][column], dt1.Columns[column].ColumnName);
        }
    }
    DataGridView1.DataSource = dt2;
}

VB.Net

Private dt1 As DataTable = New DataTable()
Private dt2 As DataTable = New DataTable()
Public Sub New()
    InitializeComponent()
    dt1.Columns.AddRange(New DataColumn() {New DataColumn("Name"), New DataColumn("01-Jan-18"), New DataColumn("02-Jan-18"), New DataColumn("03-Jan-18"), New DataColumn("04-Jan-18")})
    dt1.Rows.Add("Ahemd", "1", "1", "OFF", "OFF")
    dt1.Rows.Add("Ajith", "3", "3", "2", "2")
    dt1.Rows.Add("Soumya", "OFF", "1", "1", "1")
    Me.DataGridView1.DataSource = dt1
End Sub

Private Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
    dt2.Columns.Add("Name")
    dt2.Columns.Add("Duty")
    dt2.Columns.Add("Date")
    For row As Integer = 0 To dt1.Rows.Count - 1
        For column As Integer = 1 To dt1.Columns.Count - 1
            dt2.Rows.Add(dt1.Rows(row)(0), dt1.Rows(row)(column), dt1.Columns(column).ColumnName)
        Next
    Next
    DataGridView1.DataSource = dt2
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Convert DataGridView rows as columns in Windows Application

Company

Explore

Follow us

Contact Us