思路:从数据库中先获取数据源,然后把数据源的table表横向显示
DataTable dt = ds.Tables[0];//获取数据源中的表
DataTable dtNew = new DataTable();
dtNew.Columns.Add("ColName", typeof(string));//添加新列用以显示标题
for (int i = 0; i < dt.Rows.Count; i++)//为新Table生成列
{
dtNew.Columns.Add("Column" + (i + 1).ToString(), typeof(string));
}
foreach (DataColumn dc in dt.Columns)
{
DataRow drNew = dtNew.NewRow();
drNew["ColName"] = dc.ColumnName;
for (int i = 0; i < dt.Rows.Count; i++)
{
drNew[i + 1] = dt.Rows[i][dc].ToString();
}
dtNew.Rows.Add(drNew);
}
gvTableConvert.ShowHeader = false;
gvTableConvert.DataSource = dtNew;
gvTableConvert.DataBind();