C#建表

用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>");