急求,跪求网站后台系统登陆日志的代码`!

来源:百度知道 编辑:UC知道 时间:2024/05/13 15:41:49
如何实现请将代码发上来` 真的是急需要`

1,建个日志表-LoginLog
CREATE TABLE [dbo].[LoginLog] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [int] NOT NULL ,
[LoginTime] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LoginLog] WITH NOCHECK ADD
CONSTRAINT [PK_LoginLog] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[LoginLog] ADD
CONSTRAINT [DF_LoginLog_LoginTime] DEFAULT (getdate()) FOR [LoginTime]
GO

===================================================================
2.添加存储过程

CREATE PROCEDURE [dbo].[sp_Ins_LoginLog]
@UserID int
AS

SET NOCOUNT ON

INSERT INTO [dbo].[LoginLog] (
[UserID]
) VALUES (
@UserID
)

==================================================================
3.代码实现部分:Run.cs
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.S