Convert GridView Columns to Rows frm the sql tble saved data

ForeColor="#333333" ShowFooter="True"

Width="16px" Height="10px" style="background:#F7C7A9; margin-left: 13px; margin-bottom: 0px;">

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridView();

}

}

protected void BindGridView()

{

// string con = ConfigurationManager.ConnectionStrings["cppschConnectionString"].ConnectionString;

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

DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter("select blk_1,blk_2,blk_3,blk_4,blk_5,blk_6,blk_7,blk_8,blk_9,blk_10,blk_11,blk_12,blk_13,blk_14,blk_15,blk_16,blk_17,blk_18,blk_19,blk_20,blk_21,blk_22,blk_23,blk_24,blk_25,blk_26,blk_27,blk_28,blk_29,blk_30,blk_31,blk_32,blk_33,blk_34,blk_35,blk_36,blk_37,blk_38,blk_39,blk_40,blk_41,blk_42,blk_43,blk_44,blk_45,blk_46,blk_47,blk_48,blk_49,blk_50,blk_51,blk_52,blk_53,blk_54,blk_55,blk_56,blk_57,blk_58,blk_59,blk_60,blk_61,blk_62,blk_63,blk_64,blk_65,blk_66,blk_67,blk_68,blk_69,blk_70,blk_71,blk_72,blk_73,blk_74,blk_75,blk_76,blk_77,blk_78,blk_79,blk_80,blk_81,blk_82,blk_83,blk_84,blk_85,blk_86,blk_87,blk_88,blk_89,blk_90,blk_91,blk_92,blk_93,blk_94,blk_95,blk_96 from tbl_sch1", con);

// SqlDataAdapter da = new SqlDataAdapter("select * from tbl_sch1",con);

// SqlDataAdapter da = new SqlDataAdapter("select Blk_1,Blk_2,Blk_3,Blk_4,Blk_5,Blk_6,Blk_7,Blk_8,Blk_9,Blk_10,Blk_11,Blk_12,Blk_13,Blk_14,Blk_15,Blk_16,Blk_17,Blk_18,Blk_19,Blk_20 from tbl_sch1 ", con);

con.Open();

da.Fill(dt);

con.Close();

if (dt.Rows.Count > 0)

{

GridView1.DataSource = dt;

GridView1.DataBind();

}

}