DA/SqlExecution.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
//using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;



namespace DA
{
    public class SqlExecution
    {

        private static string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["TeaManageConnectionString"].ConnectionString;
        private static SqlConnection connection = null;
        private static SqlCommand cmd = null;



        /// <summary>
        ///  执行单条Sql语句，无返回数据
        /// </summary>
        public static bool ExecuteSqlNoReturnedData(string sqlStr)
        {
            bool isSuccessful = false;
            try
            {
                connection = new SqlConnection(connectionString);
                connection.Open();
                cmd = (SqlCommand)connection.CreateCommand();
                cmd.CommandText = sqlStr;
                cmd.ExecuteNonQuery();
                cmd.Cancel();
                connection.Close();
                isSuccessful = true;
            }
            catch (Exception exp)
            {
                string err = exp.ToString();
            }

            finally
            {
                if (null != cmd)
                {
                    cmd.Cancel();
                    cmd.Dispose();
                }
                if (null != connection)
                    connection.Dispose();
            }
            return isSuccessful;
        }

        /// <summary>
        ///  执行单条sql语句，并返回数据
        /// </summary>
        /// <returns></returns>
        public static DataSet ExecuteSqlReturnedData(string sqlStr)