用C#代码可以建表,并且可以显示代码如下
string conn = @"Data Source=.;Initial Catalog=text;Integrated Security=True";
SqlConnection sConn = new SqlConnection(conn);
sConn.Open();
//单条查询
//datatable
//dataset
//多条查询
DataTable dt = new DataTable();//添加咧
dt.Columns.Add("sID");
dt.Columns.Add("sName");
dt.Columns.Add("sAge");
dt.Columns.Add("remark");
DataRow dr1 = dt.NewRow();//添加行
dr1[0] = 1;
dr1[1] = "张三";
dr1[2] = 19;
dr1[3] = "走读";
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2[0] = 1;
dr2[1] = "李四";
dr2[2] = 20;
dr2[3] = "住校";
dt.Rows.Add(dr2);
Response.Write("<table border='1'>");//
foreach (DataRow dr in dt.Rows)
{
Response.Write("<tr>");
foreach (object obj in dr.ItemArray)
{
Response.Write("<td>");
Response.Write(obj.ToString());
Response.Write("</td>");
}
Response.Write("</tr>");
}
Response.Write("</table>");