asp Gridview控件实现增删改查含数据库脚本

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
namespace government_web.db
{
    public class SqlServerDB
    {
        /// 

        /// 打开数据库链接
        /// 

        public SqlConnection sqlcon = null;
        /// 

        /// sql 命令
        /// 

        public SqlCommand sqlcommand = null;
        /// 

        /// 数据适配器
        /// 

        public SqlDataAdapter sqlDataAdapter = null;
        /// 

        /// 缓存数据
        /// 

        public DataSet dataSet = null;
        /// 

        /// 内存表
        /// 

        public DataTable dataTable = null;

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2018-11-16 16:34  government-web\
     目录           0  2018-11-16 16:34  government-web\.vs\
     目录           0  2018-11-16 16:34  government-web\.vs\config\
     文件       85880  2018-11-16 16:34  government-web\.vs\config\applicationhost.config
     目录           0  2018-11-16 16:34  government-web\.vs\government-web\
     目录           0  2018-11-16 16:34  government-web\.vs\government-web\v14\
     文件      194560  2018-11-16 21:54  government-web\.vs\government-web\v14\.suo
     目录           0  2018-11-16 16:34  government-web\Backup\
     目录           0  2018-11-16 16:34  government-web\Backup\government-web\
     目录           0  2018-11-16 16:34  government-web\Backup\government-web\App_Data\
     文件     2359296  2014-07-02 17:10  government-web\Backup\government-web\App_Data\government.mdf
     文件      589824  2014-07-02 17:10  government-web\Backup\government-web\App_Data\government_log.ldf
     目录           0  2018-11-16 16:34  government-web\Backup\government-web\Properties\
     文件        1329  2014-07-01 21:28  government-web\Backup\government-web\Properties\AssemblyInfo.cs
     文件        1240  2014-07-01 21:28  government-web\Backup\government-web\Web.Debug.config
     文件        1301  2014-07-01 21:28  government-web\Backup\government-web\Web.Release.config
     文件         588  2014-07-01 21:38  government-web\Backup\government-web\Web.config
     目录           0  2018-11-16 16:34  government-web\Backup\government-web\db\
     文件        5030  2014-07-02 12:00  government-web\Backup\government-web\db\SqlServerDB.cs
     文件        5133  2014-07-01 23:09  government-web\Backup\government-web\government-web.csproj
     文件        1086  2014-07-01 23:09  government-web\Backup\government-web\government-web.csproj.user
     目录           0  2018-11-16 16:34  government-web\Backup\government-web\user\
     文件         458  2014-07-01 21:29  government-web\Backup\government-web\user\permission.aspx
     文件         343  2014-07-01 21:29  government-web\Backup\government-web\user\permission.aspx.cs
     文件         807  2014-07-01 21:29  government-web\Backup\government-web\user\permission.aspx.designer.cs
     文件         446  2014-07-01 21:29  government-web\Backup\government-web\user\role.aspx
     文件         337  2014-07-01 21:29  government-web\Backup\government-web\user\role.aspx.cs
     文件         801  2014-07-01 21:29  government-web\Backup\government-web\user\role.aspx.designer.cs
     文件        5906  2014-07-02 16:53  government-web\Backup\government-web\user\user.aspx
     文件        6313  2014-07-02 17:09  government-web\Backup\government-web\user\user.aspx.cs
     文件        4704  2014-07-02 16:38  government-web\Backup\government-web\user\user.aspx.designer.cs
............此处省略39个文件信息