c# - DataTable Column Values to different Coulmns of DataTable -


i have datatable 2 columns (column 1 - table name , column2 - column name) i.e.

table_name | columns_name |  sales --------------   prod_id  sales ----------------   sales_id  customer ---------   cust_id  customer ---------- cust_name   product   ------------ product_id  product   ------------ product_name

i restructure (either using existing datatable or creating new datatable) data adding each tablename , relevant field in different column i.e.

table_name1 | columns_name1 |     table_name2 | columns_name2 |    table_name3 | columns_name3 |  sales --------------   prod_id   | -----|customer ---------   cust_id  | ------- |  product   ------------ product_id    sales ----------------   sales_id |------ |customer ---------   cust_name  | ------ |   product   -------- product_name

the main datatable filled dynamically different tablenames , columnnames. please right sample code/ loop, take each table relevant field , put them sequentially in different columns.

class program {     static void main(string[] args)     {         datatable table = new datatable();         table.columns.add("table_name", typeof(string));         table.columns.add("column_name", typeof(string));          table.rows.add("sales   ", "prod_id     ");         table.rows.add("sales   ", "sales_id    ");         table.rows.add("customer", "cust_id     ");         table.rows.add("customer", "cust_name   ");         table.rows.add("product ", "product_id  ");         table.rows.add("product ", "product_name");          datatable newtable = rotatedatatable(table, 0);          foreach (datarow datarow in newtable.rows)         {             foreach (var item in datarow.itemarray)             {                 console.write("#" + item + "# ");             }             console.writeline();         }     }      private static datatable rotatedatatable(datatable table, int groupingcolumn)     {          var grouped = table.asenumerable()                 .groupby(dr => dr.itemarray[groupingcolumn])                 .select(grouping => grouping.tolist())                 .tolist();         int count = grouped.count;         int rowcount = grouped[0].count;         if (!grouped.all(g => g.count == rowcount))             throw new exception("unexpected input");           datatable newtable = new datatable();          (int = 0; < count; i++)         {             (int j = 0; j < table.columns.count; j++)                 newtable.columns.add(table.columns[j].columnname + (i + j));         }          (int = 0; < rowcount; i++)             newtable.rows.add(newtable.newrow());          (int = 0; < count; i++)         {             var list = grouped[i].tolist();             (int j = 0; j < rowcount; j++)             {                 (int k = 0; k < list[j].itemarray.length; k++)                 {                     string field = list[j].field<string>(k);                     int index = (i * table.columns.count) + k;                     newtable.rows[j].setfield<string>(index, field);                 }             }         }         return newtable;     } }

Comments

Post a Comment

Popular posts from this blog

c++ - CryptStringToBinary API behavior -

i seeing strange behavior cryptstringtobinary cryptography api. please see below code (config: x64 debug): #include "stdafx.h" #include <windows.h> #include <strsafe.h> #include <iostream> #include <exception> void main() { dword dwskip; dword dwflags; dword dwdatalen; //lpcwstr pszinput = l"jaaaaaecaaadzgaaakqaagdnnl1l56bwgfjdgr3rpxtqqqn6daw3usv2emkjym4t"; //this works fine lpcwstr pszinput = l"mytest"; //doesnt work, api returns false,error code 0x0000000d // determine size of byte array , allocate memory. if(! cryptstringtobinary( pszinput, _tcslen( pszinput ) + 1, crypt_string_base64, null, &dwdatalen, &dwskip, &dwflags ) ) { dword dw = getlasterror(); //0x0000000d: data invalid throw std::exception( "error computing byte length." ); } byte *pbytebyte = null; try { ...
Read more

c++ - Correct method for redrawing a layered window -

i have window created ws_ex_layered window style. drawing onto memory bitmap using gdi+, , using updatelayeredwindow update graphical content of layered window. intend use window main window of application, require redraw frequently. seeing layered windows not receive wm_paint windows message [?] , need come appropriate method re-drawing window. optimisation not essential , it's nice have cake , eat too. therefore, in search of "correct" method use. here thoughts far: i guess it's idea render onto off-screen bitmap before bitblt ing or similar. 60 frames rendered per second should (more than?) enough (but how compare other applications' frame rates?). possible solutions: use settimer send wm_timer message on regular basis. useful because through specifying time-out value, can achieve desired frames per second, without requirement measure duration "frame" takes rendered. would cause input or other lags due frequency , speed of m...
Read more

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more