.net 看表

 protected void Page_Load(object sender, EventArgs e)
        {
            string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\data\\Media.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            SqlConnection myConnection = new SqlConnection(str);
            myConnection.Open();
            SqlCommand myCommand = new SqlCommand("select * from News", myConnection);
            SqlDataAdapter Adapter = new SqlDataAdapter();
            Adapter.SelectCommand = myCommand;
            DataSet myDs = new DataSet();
            Adapter.Fill(myDs);
            Response.Write("<h3>新闻信息表</h3>");
            Response.Write("<table border=1 cellspacing=0 cellpadding=2>");
            DataTable myTable = myDs.Tables[0];
            Response.Write("<tr bgcolor=gray>");
            foreach (DataColumn myColumn in myTable.Columns)
            {
                Response.Write("<td>" + myColumn.ColumnName + "</td>");
            }
            Response.Write("</tr>");
            foreach (DataRow myRow in myTable.Rows)
            {
                Response.Write("<tr>");
                foreach (DataColumn myColumn in myTable.Columns)
                {
                    Response.Write("<td>" + myRow[myColumn] + "</td>");
                }
                Response.Write("</tr>");
            }
            Response.Write("</table>");
            myConnection.Close();

        }