扫一扫
分享文章到微信

扫一扫
关注官方公众号
至顶头条
| CommonScript.MessageBox("100006",this) ; | 
| public static void MessageBox(string str_ErrCode, Page page)             {                    IDataReader ErrMsg= DatabaseAccess.executeDataReader("ImportAndExport","Select ErrMessage from ErrMessage where ErrCode='" + str_ErrCode + "'");                   while (ErrMsg.Read())                   {                         String ErrMessage=ErrMsg["ErrMessage"].ToString();                         page.RegisterStartupScript("","<script>alert('"+ ErrMessage +"');</script>");                         break ;                   }             } | 
| public static IDataReader executeDataReader(String connectionString, String Sqlstr )             {                    Database db= DatabaseFactory.CreateDatabase(connectionString);                   IDataReader dr;                   DBCommandWrapper wrap = db.GetSqlStringCommandWrapper(Sqlstr);                   dr=db.ExecuteReader(wrap);                   return dr;             } | 
| <?xmlversion="1.0"encoding="utf-8"?> <dataConfiguration>  <xmlSerializerSectiontype="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null">     <enterpriseLibrary.databaseSettingsxmlns:xsd=http://www.w3.org/2001/XMLSchema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"defaultInstance="ImportAndExport"xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data">       <databaseTypes>         <databaseTypename="Oracle Database"type="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null"/>         <databaseTypename="Sql Database"type="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null"/>       </databaseTypes>       <instances>         <instancename="EA21SG3T"type="Oracle Database"connectionString="EA21SG3T"/>         <instancename="ImportAndExport"type="Sql Database"connectionString="ImportAndExport"/>         <instancename="Sql Instance"type="Sql Database"connectionString="Sql Connection String"/>       </instances>       <connectionStrings>         <connectionStringname="ImportAndExport">           <parameters>             <parametername="data source"value="192.168.1.59"isSensitive="false"/>             <parametername="database"value="ImportAndExport"isSensitive="false"/>             <parametername="pwd"value="sa"isSensitive="false"/>             <parametername="uid"value="sa"isSensitive="false"/>           </parameters>         </connectionString>         <connectionStringxsi:type="OracleConnectionStringData"name="EA21SG3T">           <parameters>             <parametername="data source"value="EA21SG3T"isSensitive="false"/>             <parametername="Password"value="developer"isSensitive="false"/>             <parametername="User Id"value="developer"isSensitive="false"/>           </parameters>           <packages/>         </connectionString>         <connectionStringname="Sql Connection String">           <parameters>             <parametername="data source"value="192.168.1.59"isSensitive="false"/>             <parametername="database"value="ImportAndExport"isSensitive="false"/>             <parametername="pwd"value="sa"isSensitive="false"/>             <parametername="uid"value="sa"isSensitive="false"/>           </parameters>         </connectionString>       </connectionStrings>     </enterpriseLibrary.databaseSettings>  </xmlSerializerSection> </dataConfiguration> | 
| if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ErrMessage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ErrMessage] GO CREATE TABLE [dbo].[ErrMessage] (       [ErrID] [int] NOT NULL ,       [ErrCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,       [ErrModul] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,       [ErrSubModul] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,       [ErrMessage] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL  ) ON [PRIMARY] GO | 
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。