C# 连接sqlserver数据库帮助类

以下是一个示例的C#帮助类，用于连接SQL Server数据库：
using System;
using System.Data.SqlClient;

public class SqlHelper
{
    private readonly string connectionString;

    public SqlHelper(string connectionString)
    {
        this.connectionString = connectionString;
    }

    public void ExecuteNonQuery(string query)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.ExecuteNonQuery();
            }
        }
    }

    public object ExecuteScalar(string query)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                return command.ExecuteScalar();
            }
        }
    }

    public SqlDataReader ExecuteReader(string query)
    {
        SqlConnection connection = new SqlConnection(connectionString);
        connection.Open();
        SqlCommand command = new SqlCommand(query, connection);
        return command.ExecuteReader();
    }
}

使用示例：
string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
SqlHelper sqlHelper = new SqlHelper(connectionString);

// 执行非查询语句
string query = "INSERT INTO YourTable (Column1, Column2) VALUES ('Value1', 'Value2')";
sqlHelper.ExecuteNonQuery(query);

// 执行查询语句并返回单个结果
query = "SELECT COUNT(*) FROM YourTable";
int count = (int)sqlHelper.ExecuteScalar(query);

// 执行查询语句并返回多个结果
query = "SELECT * FROM YourTable";
SqlDataReader reader = sqlHelper.ExecuteReader(query);
while (reader.Read())
{
    // 处理每一行数据
    string column1Value = reader.GetString(0);
    string column2Value = reader.GetString(1);
    // ...
}
reader.Close();

请注意，上述示例中的连接字符串应根据您自己的数据库配置进行修改。