二层架构连接数据库,对数据进行增删改查

在解决方案里面新添加类库,在类库里面创建一个静态实例,代码写好后,在.cs在调用这个这个类,通过调用这个类来实现数据的操作.具体代码如下:

1:数据库连接类 (SQLHelper),

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;

namespace DAL{    public class SQLHelper    {        public static int SqlConnection()        {            string connStr = @"server=op\SQLEXPRESS;database=newssystem;uid=sa;pwd=123456";            SqlConnection conn = new SqlConnection(connStr);            conn.Open();            string sql = "select * from news";            SqlCommand cmd = new SqlCommand(sql, conn);            int res = cmd.ExecuteNonQuery();            conn.Close();            return res;        }    }    }

2:.CS页面调用这个类.(先引用)

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using DAL;

public partial class sql : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {            }    protected void Button1_Click(object sender, EventArgs e)    {

        Response.Write(SQLHelper.SqlConnection());    }}

呵呵,代码很幼稚,但是我在开始了.加油.