使用DataReader获取数据库内容

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection();
String sqlconn = "Server=localhost;DataBase=Literature;Integrated Security=SSPI";
myConnection.ConnectionString = sqlconn;
myConnection.Open();
SqlCommand myCommand = new SqlCommand("select * from Works", myConnection);//SqlCommand用于对sql执行命令
SqlDataReader myReader;
myReader = myCommand.ExecuteReader();//执行select命令,结果存放在myReader中
Response.Write("<h3>SqlCommand read data</h3><hr>");
Response.Write("<table border=1 cellspacing=0 cellpadding=2>");
Response.Write("<tr bgcolor=#DAB4B4>");
for (int i = 0; i < myReader.FieldCount; i++)
{
Response.Write("<td>"+myReader.GetName(i)+"</td>");
}
Response.Write("</tr>");
while (myReader.Read())//前进到下一条记录
{
Response.Write("<tr>");
for (int i = 0; i < myReader.FieldCount; i++)
{
Response.Write("<td>" + myReader[i].ToString()+ "</td>");
}
Response.Write("</tr>");
}
Response.Write("</table>");
myReader.Close();
myConnection.Close();

}