SQLhepler用法

1. 将SQLhepler添加进来，命名空间导进来。

using Microsoft.ApplicationBlocks.Data;

2. 做连接类DBconnection：

 public class DBconnection
    {
       static string str = "server=.;database=mydb;uid=sa;pwd=901004";
        public static SqlConnection Connection ()
        {
            SqlConnection Conn = new SqlConnection(str);
            return Conn;
        }
    }

3. 做实体类如Info类：

public class Info
    {
        public string Code{ get; set; }
        public string Name { get; set; }
        public bool Sex { get; set; }
        public string Nation { get; set; }
        public DateTime Birthday { get; set; }
    }

4. 做数据访问类：

添加数据：利用SqlHelper.ExecuteNonQuery（）的重载，将需要的参数传进去。

public class InfoDA
    {
        public void Add(string code,string name,bool sex,string nation,DateTime birthday)
        {
            SqlParameter p_code = new SqlParameter("@code", code);
            SqlParameter p_name = new SqlParameter("@name", name);
            SqlParameter p_sex = new SqlParameter("@sex",sex);
            SqlParameter p_nation = new SqlParameter("@nation",nation);
            SqlParameter p_birthday = new SqlParameter("@birthday",birthday);

            SqlHelper.ExecuteNonQuery(DBconnection.Connection(), CommandType.Text, "insert into info values(@code,@name,@sex,@nation,@birthday) ",p_code,p_name,p_sex,p_nation,p_birthday);
        
        }
    }

查询数据：利用SqlHelper.ExecuteReader（）重载，将需要的数据传进去。

 public List<Info> Select()
        {
            List<Info> list = new List<Info>();

            SqlDataReader DR = SqlHelper.ExecuteReader(DBconnection.Connection(), CommandType.Text, "select * from info");

            while (DR.Read())
            {
                Info data = new Info();
                data.Code = DR["code"].ToString();
                data.Name = DR["name"].ToString();
                data.Sex = (bool)DR["sex"];
                data.Nation = DR["nation"].ToString();
                data.Birthday = (DateTime)DR["birthday"];
                list.Add(data);
            }
            return list;
        }

5. 在主函数中使用：

            InfoDA da = new InfoDA();
            List<Info> list = da.Select();

 

SQLhelper网盘地址：

http://pan.baidu.com/s/1bn913rD