sqlÁ¬½Ó´úÂë

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data.SqlClient;
namespace WebApplication1
{
   public class Message
    {
        public static IList<MessageInfo> GetMessages()
        {
            IList<MessageInfo> msgs = new List<MessageInfo>();//×Ô¶¨ÒåÁôÑÔʵÌåµÄ¼¯ºÏ
            //´ÓÅäÖÃÎļþÖлñÈ¡Á¬½Ó×Ö·û´®
            string connstr = WebConfigurationManager.ConnectionStrings["GuestBookDBConnectionString"].ConnectionString;
            //´´½¨Á¬½Ó¶ÔÏó
            SqlConnection conn = new SqlConnection(connstr);
            //´´½¨ÃüÁî¶ÔÏó
            SqlCommand cmd = new SqlCommand("select * from MsgInfo", conn);
            //´ò¿ªÊý¾Ý¿âÁ¬½Ó
            conn.Open();
            //Ö´ÐÐÃüÁî¶ÔÏóÖеÄsqlÃüÁ»ñÈ¡Êý¾Ý
            //×¢ÒâdatareaderµÄÌص㣬ֻ¶Á£¬ÏòÇ°£¬Ã¿´ÎÒ»Ìõ¼Ç¼¡£
            SqlDataReader dr = cmd.ExecuteReader();
            //Ñ­»·¶ÁÈ¡Êý¾Ý¿â¼Ç¼£¬Ã¿´ÎÒ»ÐÐ
            while (dr.Read())
            {