db.cs

这是我老师做给我们Asp.net数据库的连接里面有有网站的稍微的 设计的感觉挺吧错的

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace web.DB
{
    /// <summary>
    /// DB 的摘要说明
    /// </summary>
    public class DB
    {
        private SqlConnection dbconn;
        private SqlDataAdapter dbdater;
        private SqlCommand sqlcom;
        public DB()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        public void connection()
        {
            dbconn = new SqlConnection();
            dbconn.ConnectionString = "user id=sa;data source=localhost;Integrated security = False;initial catalog=web";
            dbconn.Open();
        }
        public DataSet selection(string str)
        {
            //com = new SqlCommand();
            //com.CommandText = str;
            //dbread = com.ExecuteReader();
            //return dbread;
            dbdater = new SqlDataAdapter(str, dbconn);
            DataSet dataset1 = new DataSet();
            dbdater.Fill(dataset1);
            return dataset1;
        }
        public void insert(string insertstr)
        {
            sqlcom = new SqlCommand();
            sqlcom.Connection = dbconn;
            sqlcom.CommandText = insertstr;
            sqlcom.ExecuteNonQuery();
        }
        public void close()
        {
            dbconn.Close();
        }
    }
}