推薦：Asp.Net發(fā)送電子郵件程序一、 asp.net 1.0及.net1.1中的做法（利用CDOSYS消息組件發(fā)送電子郵件）： 代碼如下： usingSystem; usingSystem.Web.Mail; /// summary /// 用到的類主要位于System.Web.Mail命名空間下 /// /summary publicclassSendMail { publicSendMail() { } ///summary
Asp.net的三層架構(gòu)主要是為了解決數(shù)據(jù)層，邏輯層，表示層等之間的關(guān)系。| protected int RunProcedure(string storedProcName, IDataParameter[] parameters, out int rowsAffected ) { int result; Connection.Open(); SqlCommand command = BuildIntCommand( storedProcName, parameters ); rowsAffected = command.ExecuteNonQuery(); result = (int)command.Parameters["ReturnValue"].Value; Connection.Close(); return result; } protected SqlDataReader RunProcedure(string storedProcName, IDataParameter[] parameters ) { SqlDataReader returnReader; Connection.Open(); SqlCommand command = BuildQueryCommand( storedProcName, parameters ); command.CommandType = CommandType.StoredProcedure; returnReader = command.ExecuteReader(); //Connection.Close(); return returnReader; } protected DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName ) { DataSet dataSet = new DataSet(); Connection.Open(); SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = BuildQueryCommand( storedProcName, parameters ); sqlDA.Fill( dataSet, tableName ); Connection.Close(); return dataSet; } protected void RunProcedure(string storedProcName, IDataParameter[] parameters, DataSet dataSet, string tableName ) { Connection.Open(); SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = BuildIntCommand( storedProcName, parameters ); sqlDA.Fill( dataSet, tableName ); Connection.Close(); } |
分享：Asp.Net編程基礎(chǔ)經(jīng)驗(yàn)技巧總結(jié)1.主要命名空間: %@ImportNamespace=System.Data%處理數(shù)據(jù)時(shí)用到 %@ImportNamespace=System.Data.ADO%使用ADO.net;時(shí)用到 %@ImportNamespace=System.Data.SQL%SQLServer數(shù)據(jù)庫專用 %@ImportNamespace=System.Data.XML%不用看處理XML用到 %@ImportName
新聞熱點(diǎn)
疑難解答
圖片精選
