DataBaseFactory基礎瞭解

標籤：資料   nsa   exec   exce   內建   string   cti   on()   nbsp   

 <add name="Connection str" connectionString="data source=.;pwd=12;uid=sa;database=12;" providerName="System.Data.SqlClient" />
//上面的是webconfig中的設定檔
    static string connstring_STR = "Connection str";    public static DataSet ExeQuery(string Cmd)    {        //下面的DbFactory是微軟內建的類庫，用於建立一個資料庫連結 
        //以後多用下DataBaseFactory這個詞，        Database db = DatabaseFactory.CreateDatabase(connstring_STR);        DbConnection conn = db.CreateConnection();//建立一個Db的連結通道        try        {            conn.Open();            return db.ExecuteDataSet(CommandType.Text, Cmd);//這裡執行動作        }        finally        {            conn.Close();            conn = null;        }    }

　　

//加入事務，可以復原
 public static void ExeNonQuery(string Cmd)    {        Database db = DatabaseFactory.CreateDatabase(connstring_TMS);        DbConnection conn = db.CreateConnection();        conn.Open();        DbTransaction transaction = conn.BeginTransaction();        try        {            db.ExecuteNonQuery(CommandType.Text, Cmd);            transaction.Commit();        }        catch (Exception ex)        {            transaction.Rollback();            throw ex;        }        finally        {            conn.Close();            conn = null;        }    }

　　

DataBaseFactory基礎瞭解