基本数据库操作类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Collections;
/// <summary>
///SqlOperation 的摘要说明
/// </summary>
public class SqlOperation
{

    public static readonly string ConnectionStrings = "database=Print_db;UID=Mercop;Password=2836670;";
    /// <summary>
    ///SqlOperation 的摘要说明
    /// </summary>
    /// 执行语句
    public static int ExecuteNonQuery(string cmdText)
    {
       
        using (SqlConnection connection = new SqlConnection(ConnectionStrings))
        {
            SqlCommand cmd = new SqlCommand(cmdText,connection);
            connection.Open();
            int val = cmd.ExecuteNonQuery();
            return val;
        }
    }
    /// <summary>
    /// 返回一个DataTable 对象
    /// </summary>
    public static DataTable ExecuteDataTable(string sql)
    {
        SqlCommand command = null;

        try
        {
            //Create a connection
            using (SqlConnection connection = new SqlConnection(ConnectionStrings))
            {
                command = new SqlCommand(sql, connection);
                connection.Open();
                SqlDataAdapter adapter = new SqlDataAdapter(command);
                DataSet ds = new DataSet();
                adapter.Fill(ds);
                //if(ds.Tables.Count<1)
                //    return;
                DataTable dt = ds.Tables[0];
                return dt;

            }
        }
        catch (Exception ex)
        {
            throw ex;
        }

    }
    /// <summary>
    /// 返回一行数据 ArrayList对象
    /// </summary>
    public static ArrayList ExecuteOneLine(string sql)
    {
        SqlCommand command = null;
        ArrayList DataList = new ArrayList();
        try
        {
            //Create a connection
            using (SqlConnection connection = new SqlConnection(ConnectionStrings))
            {
                command = new SqlCommand(sql, connection);
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                while(reader.Read())
                {
                    int count = reader.FieldCount;
                    for (int i=0;i<count;i++){
                        DataList.Add(reader[i]);
                    }
                }
                reader.Close();
                return DataList;
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }

    }
    /// <summary>
    /// 返回一条执行结果
    /// </summary>
    public static object ExecuteScalar(string cmdText)
    {
        using (SqlConnection connection = new SqlConnection(ConnectionStrings))
        {
            SqlCommand cmd = new SqlCommand();
            connection.Open();
            object val = cmd.ExecuteScalar();
            return val;
        }
    }
    /// <summary>
    /// 返回DataSet对象
    /// </summary>
    public static DataSet ExecuteDataSet(string sql)
    {
        SqlCommand command = null;
        try
        {
            //Create a connection
            using (SqlConnection connection = new SqlConnection(ConnectionStrings))
            {
                command = new SqlCommand(sql, connection);
                connection.Open();
                SqlDataAdapter da = new SqlDataAdapter(command);
                //创建DataSet对象
                DataSet ds = new DataSet();
                da.Fill(ds);
                //关闭连接
                connection.Close();
                return ds;
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }

    }
}