ClsDBOperation

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace myProject.App_Code
{
 /// <summary>
 /// ClsDBOperation 的摘要说明。
 /// </summary>
 public class ClsDBOperation
 {
  public ClsDBOperation()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }

  //返回一个连接对象
  private SqlConnection SqlCon()
  {
   string constr = ConfigurationSettings.AppSettings["DataBaseString"];
   SqlConnection con = new SqlConnection(constr);
   return con;
  }

  /// <summary>
  /// 返回单个表的绑定
  /// </summary>
  /// <param name="sqlstring">sql语句</param>
  /// <param name="ds">记录集合</param>
  /// <returns>-1：异常；0：成功</returns>
  public int ReDSSql(string sqlstring, out DataSet ds)
  {
   ds = new DataSet();
   try
   {
    SqlConnection con = SqlCon();
    SqlCommand cmd = new SqlCommand(sqlstring, con);
    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand = cmd;
    da.Fill(ds);
    return 0;
   }
   catch
   {
    return -1;
   }
  }
  

  /// <summary>
  /// 不返回集合的SQL语句执行
  /// </summary>
  /// <param name="sqlstring">sql语句</param>
  /// <returns>-1：异常；0：成功；</returns>
  public int ExeNonSql(string sqlstring)
  {
   SqlConnection con = SqlCon();
   SqlCommand cmd1 = new SqlCommand(sqlstring,con);

   try
   {
    con.Open();
    cmd1.ExecuteNonQuery();
    return 0;
   }
   catch
   {
    return -1;
   }
   finally
   {
    con.Close();
   }
  }
 }
}