hey frds I want to fetch data from a column and display it as a row that's called pvorting !!!! may u pls help me out?

private DataTable PivotTable(DataTable origTable)
{
DataTable newTable = new DataTable();
DataRow dr = null;

//Add Columns to new Table
------------------------------
for (int i = 0; i <= origTable.Rows.Count; i++)
{
newTable.Columns.Add(new DataColumn(origTable.Columns[i].ColumnName, typeof(String)));
}
//Execute the Pivot Method
for (int cols = 0; cols < origTable.Columns.Count; cols++)
{
dr = newTable.NewRow();
for (int rows = 0; rows < origTable.Rows.Count; rows++)
{
if (rows < origTable.Columns.Count)
{
dr[0] = origTable.Columns[cols].ColumnName;
// Add the Column Name in the first Column
dr[rows + 1] = origTable.Rows[rows][cols];
}
}
newTable.Rows.Add(dr); //add the DataRow to the new Table rows collection
}
return newTable;
--------------------------------------------------------------------------
This method is used to fill grid view
------------------------------------------------
private void BindGridView()
{
try
{

string sqlStatement = "SELECT Top(5)* FROM Customers";
SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
//Bind the First GridView with the original data from the DataTable
GridView1.DataSource = dt;
GridView1.DataBind();

//Pivot the Original data from the DataTable by calling the
//method PivotTable and pass the dt as the parameter
DataTable pivotedTable = PivotTable(dt);
GridView2.DataSource = pivotedTable;
GridView2.DataBind();

}
}
catch (Exception ex)
{
lblMsg.Text="Error:"+ex.Message.ToString();
}

-------------------------------------------------------------------
You can call bindgrid method where u want.just i wnt to call in page load event
--------------------------
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGridView();
}
}