ASP.NET中SQL Server数据库访问通用类(6)

                    foreach (SqlParameter parameter in parameters)
                    {
                        command.Parameters.Add(parameter);
                    }
                }
                connection.Open();
                count = command.ExecuteNonQuery();
            }
        }
        return count;
    }

该类全部代码
  View Code
using System;
using System.Data;
using System.Data.SqlClient;

public class SqlDbHelper
{
    //私有字段
    private string connectionString;
    //公共属性 数据库连接字符串
    public string ConnectiongString
    {
        set { connectionString = value; }
    }

    #region 构造函数

    /// <summary>
    /// 构造函数
    /// </summary>
    public SqlDbHelper()
    {
    }

    /// <summary>
    /// 构造函数www.2cto.com
    /// </summary>
    /// <param name="strConnectionString">数据库连接字符串</param>
    public SqlDbHelper(string strConnectionString)
    {
        this.connectionString = strConnectionString;
    }

    #endregion

    #region 执行一个查询，并返回结果集

    /// <summary>
    /// 执行一个查询，并返回结果集
    /// </summary>
    /// <param name="sql">要查询的SQL文本命令</param>
    /// <returns>查询结果集</returns>
    public DataTable ExecuteDataTable(string sql)
    {
        return ExecuteDataTable(sql, CommandType.Text, null);
    }

    /// <summary>