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();
}