MyNewsDAL/DBHelper.cs

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

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

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

namespace MyNewsDAL
{
  public  class DBHelper
    {
      private static string constr="server=.\\sql2005;database=NewsManager;uid=sa;pwd=sa";
      private static SqlConnection conn = new SqlConnection(constr);

      /// <summary>
      /// 执行增删改SQL语句的方法
      /// </summary>
      /// <param name="sql"></param>
      /// <returns></returns>
      public static int ExecuteCommand(string sql)
      {
          try
          {
              conn.Open();
              SqlCommand cmd = new SqlCommand(sql, conn);
               return cmd.ExecuteNonQuery();             

          }
          catch (Exception ex)
          {
              throw ex;
          }
          finally
          {
              if (conn.State == ConnectionState.Open)
              {
                  conn.Close();
              }

          }
      }
      /// <summary>
      /// 返回查询结果第一行第一列
      /// </summary>
      /// <param name="sql"></param>
      /// <returns></returns>
      public static object GetSchalar(string sql)
      {
          try
          {
              conn.Open();
              SqlCommand cmd = new SqlCommand(sql, conn);
              return cmd.ExecuteScalar();
          }
          catch (Exception ex)
          {
              throw ex;
          }
          finally
          {