使用函數傳遞參數來執行數據庫操作

　　using System;
using SystemConfiguration;
using SystemDataSqlClient;
using SystemData;
using SystemCollections;
比如
// 打開數據庫

轉自動態網制作指南
public static SqlConnection OpenConnection()
  {
   SqlConnection mysqlConn = new SqlConnection(ConfigurationSettingsAppSettings[connstring]);
  

　　try
   {
    mysqlConnOpen();
   }
   catch (Exception e)
   {
    //rethrow this exception
    throw e;
   }

　　return mysqlConn;
  }

　　// 執行SQL返回DataSet
public static DataSet GetDataSet(string SQLQuery)
  {
   SqlConnection cn = DBObjectOpenConnection();
   SqlDataAdapter da = new SqlDataAdapter(SQLQuery cn);
   DataSet ds = new DataSet();
  
   daFill(ds);
  
   //release resources
   daDispose();
   da = null;
   cnClose();
   cn = null;

　　return ds;
  }

　　// 執行SQL語句
public static void ExecuteUpdateQuery(string SQLQuery)
  {
   SqlConnection cn = DBObjectOpenConnection();
   SqlCommand cmd = new SqlCommand();

　　cmdCommandText = SQLQuery;
   cmdCommandType = CommandTypeText;
   cmdConnection = cn;
   cmdExecuteNonQuery();
  
   cnClose();
   cn = null;
  }

From:http://tw.wingwit.com/Article/program/net/201311/13695.html