Login form using local database

Question

i wnat create a login form using local database loginuser table plz help me.

Ashish Hada · Answer

but i want to do it in c#

Talaviya Bhavdip · Answer

#region Login [HttpPost] //loginmethod public string Login( string username, string password, Boolean chkRememberMe) { MST_Customer objMST_Customer = new MST_Customer(); if (objMST_Customer.CusData != null ) { if (chkRememberMe == true ) { Response.Cookies[ "UserName" ].Expires = DateTime.Now.AddDays(30); Response.Cookies[ "Password" ].Expires = DateTime.Now.AddDays(30); } else { Response.Cookies[ "UserName" ].Expires = DateTime.Now.AddDays(-1); Response.Cookies[ "Password" ].Expires = DateTime.Now.AddDays(-1); } Response.Cookies[ "UserName" ].Value = username; Response.Cookies[ "Password" ].Value = password; stRet = "success" ; } else { stRet = "login failed" ; } return stRet; } first you have to create login form in view in mvc form action ="@Url.Action("Login", "Login ")" method = "post" > div class = "form-group has-feedback" > input type = "email" class = "form-control required btnlogin" placeholder = "Email" id = "Username" name = "Username" value = "@ViewBag.UserName" maxlength = "50" autofocus tabindex = "1" > span class = "glyphicon glyphicon-envelope form-control-feedback" > span > div > div class = "form-group has-feedback" > input type = "password" class = "form-control required btnlogin" placeholder = "Password" id = "Password" name = "Password" value = "@ViewBag.Password" maxlength = "15" tabindex = "2" > span class = "glyphicon glyphicon-lock form-control-feedback" > span > div > div class = "row" > div class = "col-xs-1" > div > div class = "col-xs-6" > div class = "checkbox icheck" > label > input type = "checkbox" id = "chkRememberMe" class = "btnlogin" name = "chkRememberMe" checked = "@Checkremember" tabindex = "3" > Remember Me label > div > div > div class = "col-xs-4" style = "float: right;" > button type = "button" class = "btn btn-primary btn-block btn-flat" onclick = "Login();" tabindex = "4" > Sign In button > div > div > form > in this login() function make one ajax call in controller $.ajax({ url: '@Url.Action("Login", "Login")' , type: 'POST' , data: JSON.stringify({ "Username" : $( "#Username" ).val(), "Password" : $( "#Password" ).val(), "chkRememberMe" : $( "#chkRememberMe" ).prop( 'checked' ), "Subdomain" : "www." + subDomain }), dataType: "json" , contentType: "application/json; charset=utf-8" , }).done( function (result) { if (result== "success" ) { alert( 'login success' ); } else { alert( 'login falied' ); } }).fail( function (result) { alert( 'login falied' ); }); } } then make code in controller for the login method. #region Login [HttpPost] //loginmethod public string Login( string username, string password, Boolean chkRememberMe) { MST_Customer objMST_Customer = new MST_Customer(); if (objMST_Customer.CusData != null ) { if (chkRememberMe == true ) { Response.Cookies[ "UserName" ].Expires = DateTime.Now.AddDays(30); Response.Cookies[ "Password" ].Expires = DateTime.Now.AddDays(30); } else { Response.Cookies[ "UserName" ].Expires = DateTime.Now.AddDays(-1); Response.Cookies[ "Password" ].Expires = DateTime.Now.AddDays(-1); } Response.Cookies[ "UserName" ].Value = username; Response.Cookies[ "Password" ].Value = password; stRet = "success" ; } else { stRet = "login failed" ; } return stRet; } add the class in model of customer in this project public partial class MST_Customer { public int Party_ID { get ; set ; } public string username{ get ; set ; } public string password{ get ; set ; } } I hope you like this.

Login form using local database

Answers (2)