how to convert datatable into different form of datatable in c#

Sandeep Kumar

I have A datatable and want to convert in below datatable

Expected datatable Result:

Helmet_GP	Helmet_SId	Helmet_Activity	Helmet_Ua	Guard_Gp	Guard_SId	Guard_Activity	Guard_Ua	Mask_Gp	Mask_Sid	Mask_activity	Mask_Ua
2	15	Helmet	4	3	16	Guard	5	6	17	Mask	8

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari4y ago
Accepted answer
In C#, use the following code to get your desired result:
public void ShowResult()
{
    DataTable sourceTable = resultDS.Tables[0];
    DataTable finalTable = new DataTable();
    finalTable.Rows.Add();
    for (int i = 0; i < sourceTable.Rows.Count; i++)
    {
        var Activity = sourceTable.Rows[i]["Activity"];

        for (int j = 1; j < sourceTable.Columns.Count; j++)
        {
            var colName = sourceTable.Columns[j].ColumnName;
            var colNameVal = sourceTable.Rows[i][j];

            if(colName == "Activity")
                finalTable.Columns.Add(Activity + "_" + colName, typeof(string));
            else
                finalTable.Columns.Add(Activity + "_" + colName, typeof(int));
            finalTable.Rows[0][Activity + "_" + colName] = colNameVal;
        }
    }
}
Final Result:
+2
suraj devgade4y ago
In SQL, we need to use pivot function in which we can convert rows to columns functionality in customized way.
+1
Sandeep Kumar4y ago
in c#
+1
Nitin Sontakke4y ago
Please make up your mind.

You want solution in C# or in SQL Server?
+1