Code to Invert a Datagrid

Hope this helps...

public void InvertDS(ref DataSet ds)
{
try
{
DataSet ds2 = new DataSet();
ds2.Tables.Add();
ds2.Tables[0].Columns.Add();
ds2.Tables[0].Columns.Add();

for(int i=0; i < ds.Tables[0].Columns.Count; i++)
{
object [] array = new object[2];
array[0] = ds.Tables[0].Columns[i].ColumnName;
array[1] = ds.Tables[0].Rows[0][i];
ds2.Tables[0].Rows.Add(array);
}

ds = ds2;
}
catch(Exception ex)
{
string s = ex.ToString();
}
}