try something like the following (did not test, so there might be oversight)DataTable dt=null; if (!dr.Read()) { dt = new DataTable("TableName"); DataTable sh = dr.GetSchemaTable(); foreach (DataRow tr in sh.Rows) { dt.Columns.Add(tr["ColumnName"].ToString(),tr["DataType"]); } DataRow row = dt.NewRow(); dt.Rows.Add(row); row = dt.NewRow(); dt.Rows.Add(row); }if (dt !=null) DataGrid1.DataSource = dt;
谢谢! 我程序里用的是VB所以saucer(思归)的程序did not test too,sorry, 思路是一样的.现在不绑定了,改成程序控制了,再次感谢.
if (!dr.Read())
{
dt = new DataTable("TableName");
DataTable sh = dr.GetSchemaTable();
foreach (DataRow tr in sh.Rows)
{
dt.Columns.Add(tr["ColumnName"].ToString(),tr["DataType"]);
} DataRow row = dt.NewRow();
dt.Rows.Add(row); row = dt.NewRow();
dt.Rows.Add(row);
}if (dt !=null)
DataGrid1.DataSource = dt;
我程序里用的是VB所以saucer(思归)的程序did not test too,sorry,
思路是一样的.现在不绑定了,改成程序控制了,再次感谢.