USERSAUDIT FOR MY WEB PAGE

Question

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.

Praveen Kumar Sreeram · Answer

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 Rajendran · Answer

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 Kumar Sreeram · Answer

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 Rajendran · Answer

how can i implement for this code....send me example r reference plz ?

Vignesh Mani · Answer

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 Kumar Sreeram · Answer

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