asp.net web 三层架构

## 如何用三层架构把数据添加到数据库。   记得要引用

首先创建好三个库类Model,DAL,BLL,然后再创建。						asp.net web (Net.Framwork)命名为WebUI。

Model:模型层
 public class Picture
    {
          
        //数据库
        //userName nvarchar(50),
        //pwd nvarchar(50),
        //phone nvarchar(50),

        public string userName {
    get; set; }
        public string pwd {
    get; set; }
        public string photo {
    get; set; }
    }

DAL:数据访问层  创建DAL之后引用模型层![在这里插入图片描述](https://img-blog.csdnimg.cn/20210310200334517.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTk3Mjg4Nw==,size_16,color_FFFFFF,t_70#pic_center)


在DAL里面把    DBHelper类里面把增删改数据写好

```csharp
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
   
    public class DBHelper
    {
   
        //public static  String connString = ConfigurationSettings.AppSettings["connString"];
        public static String conStr = "Data Source =.; Initial Catalog = BuleWhale; Integrated Security = True";

        //1.查询
        //public static readonly string conStr = "Data Source=.;Initial Catalog=UserSesc;Integrated Security=True";

        //打开数据库连接
        public static SqlConnection conn = null;
        public static void InitConnection()
        {
   
            if (conn == null || conn.State != ConnectionState.Connecting)
            {
   
                conn = new SqlConnection(conStr);
            }
            if (conn.State == ConnectionState.Broken)
            {
   
                //conn.Close();
                conn.Open