操作sql语句公共部分

• 数据库增删改查，很多地方都是操作重复代码，可以写一个公共的方法，把相同的代码放在一个或几个方法里面。以节省不必要的代码编写。

---

 

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; namespace Public_DataBase_Manipulate_Way { public class Common { //数据库连接字符串，从配置文件读取。 public string connectString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]; /// <summary> /// 返回dataset方法， select语句 /// </summary> /// <param name="sql"> sql语句</param> /// <returns></returns> public DataSet GetDataSet(string sql) { DataSet ds = new DataSet(); try { using (SqlConnection conn = new SqlConnection(connectString)) { SqlDataAdapter da = new SqlDataAdapter(sql, conn); da.Fill(ds, "table1"); return ds; } } catch (Exception) { return ds; } } /// <summary> /// 返回受影响的行数 update,delete,insert /// </summary> /// <param name="sql">sql语句</param> /// <returns></returns> public int Update_Delete_Insert(string sql) { int result = 0; try { using (SqlConnection conn = new SqlConnection(connectString)) { conn.Open(); SqlCommand command = new SqlCommand(sql, conn); result = command.ExecuteNonQuery(); return result; } } catch (Exception) { return result; } } } }