Posts

Showing posts from November, 2011

Transpose a DataTable using DataSet (C#)

DataSet ds = new DataSet(); OracleDataAdapter dataAdapter = new OracleDataAdapter(); dataAdapter.SelectCommand=cmd; DataAdapter.Fill(ds); DataTableCollection collection = ds.Tables;                         DataTable table=new DataTable();                         for (int i = 0; i < collection.Count; i++)                         {                             table = collection[i];                     ...