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())
            {
                //将数据库中的记录内容存到留言实体中
                MessageInfo m = new MessageInfo();
                m.MsgID = int.Parse(dr["MsgID"].ToString());
                m.Title = dr["Title"].ToString();
                m.Body = dr["Body"].ToString();
                m.AuthorName = "Daniel";
                m.AddedTime = DateTime.Now;

                //将该留言实体添加到集合中
                msgs.Add(m);
            }
            dr.Close();
            conn.Close();

            return msgs; //返回留言实体集合
       
        }
   
    }

    /// <summary>
    /// 留言实体类
    /// </summary>
    public class MessageInfo
    {
        public int MsgID
        { get; set; }

        public string Title
        {
            get;
            set;
        }
        public string Body
        {
            get;
            set;
        }
        public string AuthorName
        {
            get;
            set;
        }
        public DateTime AddedTime
        {
            get;
            set;
        }

    }
}