Couldn't able to convert rows to columns

Question

0.00/5 (No votes)

See more:

DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("Col1", typeof(string)));
dt.Columns.Add(new DataColumn("Col2", typeof(string)));
dt.Columns.Add(new DataColumn("Col3", typeof(string)));
dt.Columns.Add(new DataColumn("Col4", typeof(string)));
dr = dt.NewRow();
dr["Col1"] = string.Empty;
dr["Col2"] = string.Empty;
dr["Col3"] = string.Empty;
dr["Col4"] = string.Empty;

C#

dr = dt.NewRow();
                dr["Col1"] = string.Empty;
                dr["Col2"] = string.Empty;
                dr["Col3"] = string.Empty;
                dr["Col4"] = string.Empty;

dr = dt.NewRow();
ViewState["CurrentTable"] = dt;

On page load, I used to load 2 rows in gridview. The gridview is bound with the BoundField..
I need to convert the 2 rows to columns wise. Surfed many websites but no changes are happening.... Can anyone share me the apt website to convert rows to columns....

Posted 8-May-14 20:11pm

Sriram Ramachandran

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2014-05-08T20:18:00

Solution 1

check this link

Transpose a DataTable using C#[^]

Posted 8-May-14 20:18pm

Karthik_Mahalingam

Comments

Sriram Ramachandran 9-May-14 2:42am

I got the output as expected when I use Checkpoint and see the output in Datasource...But the output in browser its different .... Don't no whats happening??

Sriram Ramachandran 9-May-14 6:09am

Friends Someone help me ... I couldn't find the problem....

Sriram Ramachandran 9-May-14 6:17am

DataTable outputTable = new DataTable();

// Add columns by looping rows

// Header row's first column is same as in inputTable
outputTable.Columns.Add(inputTable.Columns[0].ColumnName.ToString());

// Header row's second column onwards, 'inputTable's first column taken
foreach (DataRow inRow in inputTable.Rows)
{
string newColName = inRow[0].ToString();
outputTable.Columns.Add(newColName);
}

// Add rows by looping columns
for (int rCount = 1; rCount <= inputTable.Columns.Count -1; rCount++)
{
DataRow newRow = outputTable.NewRow();

// First column is inputTable's Header row's second column
newRow[0] = inputTable.Columns[rCount].ColumnName.ToString();
for (int cCount = 0; cCount <= inputTable.Rows.Count - 1; cCount++)
{
string colValue = inputTable.Rows[cCount][rCount].ToString();
newRow[cCount + 1] = colValue;
}
outputTable.Rows.Add(newRow);

}
return outputTable;

Is this the code wrong? Got output when I make cheeckpoints in coding but not in output screen ??