USERSAUDIT FOR MY WEB PAGE

Geetha Rajendran

10y876.NET

                 I want to check (Report) how many users login for my web page ...and also stored for Failed login list into my table....how can tract this history. Friends please help for me to solve this task......kindly share me any reference examples.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Praveen Sreeram10y ago
You might write a stored Procedure for validating the user credentials.. it would be somehting like this..
create procedure usp_ValidateCredentials
@username varchar(50),
@Password varchar (50)
as
@count int
Select @count = count(*) from User
where username = @username and password=@Password
if @count>0
begin
--if the control comes here, credentials are valid so insert 1 for this user
Write the Insert query for inserting a recor into the LoginAudit table with the value 1 in the Success column
end
else
--if the control comes here, credentials are in-valid so insert 0 for this user
Write the Insert query for inserting a record here into the LoginAudit table with the value 0 in the Success column
begin
end
Thanks,
Prawin
Geetha Rajendran10y ago
Thankyou friends.....
Success status for my login - If the credentials are valid, store "1" otherwise store "0"
how its possible to do this...i want to insert 1 or 0 (it depends login status true or false)
into my sql table.
Praveen Sreeram10y ago
Please refer the following articles
1) Grid View Example: http://www.c-sharpcorner.com/UploadFile/7eb164/gridview-control-in-Asp-Net/
2) Insert data into data example - http://www.c-sharpcorner.com/UploadFile/5d065a/insert-data-into-database-in-window-form/
You give a try. If you face any errors, we will help you.
Thanks,
Prawin
Geetha Rajendran10y ago
how can i implement for this code....send me example r reference plz ?
Vignesh Mani10y ago
Hi Yar,
Create one table like Log in sql server with what are the field you need like username , Login status(success or fail).
Just crate one method for insert into database. whenever user enter just call you created method.
You need to implement if username and password correct status success otherwise fail.
Praveen Sreeram10y ago
Hi,
You need to create a table named "Loginaudit" with the following columns.
LoginUsername (Varchar)
DateTime (DateTime)
Success (Boolean)
For each Login button click, after you validate the credentials, store the following values.
LoginUsername - value that the user has entered for this username
DateTime - Current Date time
Success - If the credentials are valid, store "1" otherwise store "0"
Now, create a page with Grid View control to display the data available in the "LoginAudit" table.
Hope it is clear.
Thanks,
Prawin