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