ASP.NET中自定义提示对话框_[Asp.Net教程]

























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("","");






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里的内容(粗体部分)：



















































































































































































































































































































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

源自：hufengwen