Display Rows as Columns in Gridview in Asp.net using C#, VB.

Am having a saved data's in the sql table and wanna display dat columns as rows and rows as a column in the output gridview pls help me...

this is for normal view,bt i need for another change

protected void Page_Load(object sender, EventArgs e)

{

string un = Session["Uname"].ToString();

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["App"].ToString());

DataTable dt = new DataTable();

SqlCommand sqlCommand = new SqlCommand("select TOP 30 * from tbl_sch1 where [USER NAME]='" + un + "'", con);

con.Open();

SqlDataReader reader = sqlCommand.ExecuteReader();

GridView1.DataSource = reader;

GridView1.DataBind();

}