1:在SQL2005/2008企业管理器中,打开查询分析器增加一个数据库表
CREATE TABLE [dbo].[Admin_EmpOtherDuty](
[EimID] [int] IDENTITY(1,1)NOT NULL,
[EmpCode] [varchar](20)COLLATEChinese_PRC_CI_AS NOT NULL,
[ComID] [int] NOT NULL,
[DeptID] [int] NOT NULL,
[DutyID] [int] NOT NULL,
[StateID] [int] NOT NULL CONSTRAINT[DF_Admin_EmpOtherDuty_StateID] DEFAULT ((0)),
[AreaID] [int] NOT NULL CONSTRAINT[DF_Admin_EmpOtherDuty_AreaID] DEFAULT ((0)),
[BTime] [datetime] NULL,
[ETime] [datetime] NULL,
[InputAccount] [varchar](20)COLLATEChinese_PRC_CI_AS NULL,
[InputTime] [datetime] NOT NULL CONSTRAINT[DF_Admin_EmpDuty_InputTime] DEFAULT (getdate()),
[Statu] [char](1)COLLATEChinese_PRC_CI_AS NOT NULLCONSTRAINT [DF_Admin_EmpDuty_Statu] DEFAULT ('Y'),
[Memo] [nvarchar](100)COLLATEChinese_PRC_CI_AS NULL,
CONSTRAINT[PK_Admin_EmpDuty] PRIMARY KEY CLUSTERED
(
[EimID] ASC
)WITH(PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
2:打开VS2010设计WEB界面,在页面上添加控件,控件ID要和数据库字段名字一致。
3:一行代码实现数据插入
if(iBizSQL.Insert("Admin_EmpOtherDuty",this)) //传入表名就好了
JSUtility.AlertAndRedirect("增加成功","EmpDutyAdd.aspx");
else
JSUtility.Alert(this,"添加失败");
4:一行代码实现更新数据
if (id != "0")
{
if(iBizSQL.Update("Admin_EmpOtherDuty",this))// 传入表名就好了
JSUtility.Alert(this,"更新成功");
else
JSUtility.Alert(this,"更新失败¹");
}
5,删除,查询页是一行代码,略欢迎下载EasyPlat.net测试使用
萧 QQ:775066802
技术支持QQ群 293588155