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参考