[ 来源:www.it55.com | 作者: | 时间:2007-07-15 | 收藏 | 推荐 ] 【大 中 小】
1.在需要的地方调用下面的方法:CommonScript.MessageBox("100006",this) ; 2.上面用到的CommonScript类里的MessageBox方法: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 ; } } 3. 上面用到的DatabaseAccess类里的executeDataReader方法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; } 4.上面用到的连接串ImportAndExport在dataconfiguration.config里的内容(粗体部分):<?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> 5.数据库: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 www.it55.com在线教程
源自:hufengwen
(编辑:IT资讯之家 www.it55.com)