实现我们的数据库访问 ASP.NET 里面的DBHelper 工具类的编写

    public readonly static string strConn = ConfigurationManager.ConnectionStrings["Access"].ConnectionString.ToString();

    //查询
    public static DataTable GetDataTable(string strSql,params SqlParameter[] sp)
    {
        // 连接断开 释放资源 
        using (SqlConnection conn = new SqlConnection(strConn))
        {
            //数据表
            DataTable dt = new DataTable();
            //判断连接的状态是否是 关闭
            if (conn.State == ConnectionState.Closed)
            {
                //如果关闭 就打开
                conn.Open();
                //执行
                SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
                //实现我们的参数化 
                if (sp != null)
                {
                    sda.SelectCommand.Parameters.AddRange(sp);
                }
                //刷新
                sda.Fill(dt);
            }
            return dt;
        }
    }

    //增  删 改
    public static int ExecuteNonQuery(string strSql,params SqlParameter[] sp)
    {
        int result = 0;
        // 连接断开 释放资源 
        using (SqlConnection conn = new SqlConnection(strConn))
        {
            //判断连接的状态是否是 关闭
            if (conn.State == ConnectionState.Closed)
            {
                //如果关闭 就打开
                conn.Open();
                //执行
                SqlCommand smd = new SqlCommand(strSql, conn);
                //SqlDataAdapter sda = new SqlDataAdapter(smd);
                if (sp != null)
                {
                    //  sda.SelectCommand.Parameters.AddRange(sp);
                    smd.Parameters.AddRange(sp);

                }
                //返回结果集
                result = smd.ExecuteNonQuery();
            }
        }
        return result;
    }