C # transpose rows and columns in datatable

Http://blog.csdn.net/diyoosjtu/article/details/7581734

 

Transpose rows and columns in the datatable, so you must first fill your data in the datatable.

Assume that your original ale is DT and add the following statement after dt

 

Datatable dtnew = new datatable ();
Dtnew. Columns. Add ("columnname", typeof (string ));
For (INT I = 0; I <DT. Rows. Count; I ++)
{
Dtnew. Columns. Add ("column" + (I + 1). tostring (), typeof (string ));
}
Foreach (datacolumn DC in DT. columns)
{
Datarow drnew = dtnew. newrow ();
Drnew ["columnname"] = Dc. columnname;
For (INT I = 0; I <DT. Rows. Count; I ++)
{
Drnew [I + 1] = DT. Rows [I] [DC]. tostring ();
}
Dtnew. Rows. Add (drnew );
}