c# - Best way to transfer table's column entries to another table's rows -

c# - Best way to transfer table's column entries to another table's rows -

i have write program, transfers info table table under above shown restrictions in visual studio 2010 c# , sql server 2012. problem find highly efficient algorithm that, because tables long

private static void fillrows() { //i have list<string> rows; // list table1 names (a,b,c,d,e...) list<string> columnlist; //list table2 columnnames (a#mm,b#cm,c#m...) using (sqlconnection connection = new sqlconnection(connectionstring)) { using (var command = connection.createcommand()) { } } }

you can pivot table or result set

more details

c# sql-server visual-studio-2010