資料庫表的轉置,橫向顯示資料,並綁定到gridview

  public void InsTimes(string sqlstr)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = str;
            try
            {
                con.Open();

                SqlDataAdapter adpt = new SqlDataAdapter(sqlstr, con);
                DataTable InsTimesTable = new DataTable();
                adpt.Fill(InsTimesTable);

                DataTable ITTNew = new DataTable();
                ITTNew.Columns.Add("ColumnName", typeof(string));//列名
                for (int i = 0; i < InsTimesTable.Rows.Count; i++)
                {
                    ITTNew.Columns.Add("Column" + (i + 1).ToString(), typeof(string));
                }
                foreach (DataColumn dc in InsTimesTable.Columns)
                {
                    DataRow drNew = ITTNew.NewRow();
                    drNew["ColumnName"] = dc.ColumnName;
                    for (int i = 0; i < InsTimesTable.Rows.Count; i++)//顯示資料
                    {
                        drNew[i + 1] = InsTimesTable.Rows[i][dc].ToString();
                    }
                    ITTNew.Rows.Add(drNew);
                }

               
                GridView1.DataSource = ITTNew;//設定資料來源 
                GridView1.DataBind();
            }
            finally
            {
                con.Close();
            }
        }
    }

部分從http://hi.baidu.com/m_dondon/blog/item/7e4e53cf1c845638f8dc61d8.html參考