Create Login API in C# ASP.NET VS 2010

Question

Dear all friends,,, I want create simple login web form.... But i want check userid and password through API.... So, please suggest me how to handle this type task...

Amit Kumar Singh · Answer

http://www.c-sharpcorner.com/UploadFile/2b481f/simple-login-form-in-web-api/

Yogesh Sharma · Answer

can you explain me how to data table check it ???

Yogesh Sharma · Answer

Thanks to all of you ............ So finally i have created Login API... See as below : This is My Model : using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace API_Demo.Models { public class LoginModel { public string Acc_Email_ID { get; set; } public string Password { get; set; } } } This is my controller : using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using API_Demo.Models; namespace API_Demo.Controllers { public class HomeController : Controller { public ActionResult Index() { LoginModel obj = new LoginModel(); return View(obj); //For bind the view } [HttpPost] public ActionResult Index(LoginModel objuserlogin) { var display = Userloginvalues().Where(m => m.Acc_Email_ID == objuserlogin.Acc_Email_ID && m.Password == objuserlogin.Password).FirstOrDefault(); if (display != null) { ViewBag.Status = "CORRECT UserNAme and Password"; } else { ViewBag.Status = "INCORRECT UserName or Password"; } return View(objuserlogin); } public List Userloginvalues() { List objModel = new List (); objModel.Add(new LoginModel { Acc_Email_ID = "user1", Password = "password1" }); return objModel; } } } This is my view : @model API_Demo.Models.LoginModel @{ ViewBag.Title = "Index"; } function display() { if ($("#txtusername").attr("value") == "") { alert("Please Enter your UserName."); return false; } else if ($("#txtuserpassword").attr("value") == "") { alert("Please enter UserPassword."); return false; } alert("Login Successfully"); return true; } Simple We API Login Form @using (Html.BeginForm("Index", "Home")) { @ViewBag.Status User Name : @Html.TextBoxFor(m => m.Acc_Email_ID, new { @style = "width:200px", @id = "txtusername" }) User Password : @Html.PasswordFor(m => m.Password, new { @style = "width:200px", @id = "txtuserpassword" }) } So, in this API i have checked the id and password offline... (i.e. already defined)... But, i want check userid and password from sql table ... So, please suggest me how to check from sql table....

Yogesh Sharma · Answer

Thanks for your reply... But your article is about login with sp... but i want api not sp or query....

Amit Kumar Singh · Answer

http://www.c-sharpcorner.com/UploadFile/0c1bb2/login-page-in-Asp-Net-C-Sharp-web-application-using-stored-proce/

Yogesh Sharma · Answer

yes

Yogesh Sharma · Answer

asp.net

Krishna Rajput Singh · Answer

use my links

Amit Kumar · Answer

Hi dear, U want to do it in Asp.net or MVC.

Amit Kumar Singh · Answer

u want to create asp.net application through database...i am rit

Yogesh Sharma · Answer

i tired since last three days.. no any solutions found so, please help me...

Yogesh Sharma · Answer

Dear Amit Kumar, Can you explain with gui....because its my first api

Krishna Rajput Singh · Answer

Hello Yogesh Sharma thanks for writing below links i hope helpful for you......:) http://www.c-sharpcorner.com/UploadFile/81a718/3-simple-steps-to-create-your-first-Asp-Net-web-api-service/ https://code.msdn.microsoft.com/ASPNET-Web-API-JavaScript-d0d64dd7 http://www.dotnet-tricks.com/Tutorial/webapi/E3K8220314-Securing-ASP.NET-Web-API-using-basic-Authentication.html

Amit Kumar Singh · Answer

IF EXISTS(SELECT USERID,PASSWORD FROM EMPLOYEE WHERE USERID=@USERID AND PASSWORD=@PASSWORD) BEGIN SELECT 'LOGIN WAS SUCCESSFULLY' END ELSE BEGIN SELECT 'USERID AND PASSWORD WAS INCORRECT' END

Amit Kumar · Answer

Ok , Check it my above Post again ... I have use database for login...

Yogesh Sharma · Answer

Thanks for your quick reply.... But, i want to check userid and password from sql table...

Amit Kumar · Answer

Hi Yogesh, Create a MVC application. First take a model class : namespace MvcApplicationLogin.Models { public class LoginModel { public string UName { get; set; } public string UPassword { get; set; } } } Create its view : function showlog() { if ($("#txtuname").attr("value") == "") { alert("Please enter user name."); return false; } else if ($("#txtu password").attr("value") == "") { alert("Please enter Password."); return false; } alert("Login Successfully"); return true; } @using (Html.BeginForm("Index", "Home")) { @ViewBag.Status User Name : @Html.TextBoxFor(m => m.UName, new {@style="width:100px",@id="txtuname" }) User Password : @Html.PasswordFor(m => m.U Password, new {@style="width:100px",@id="txtupassword" }) } Create your controller here like: public class HomeController : Controller { public ActionResult Index() { //Create loginModel object here LoginModel obj = new LoginModel(); return View(obj); //For bind the view } //when user enter usernaem and password after that this event is fire.. [HttpPost] public ActionResult Index(LoginModel usrlogin) { if(Convert.ToString(dt.rows(0)("0"))=usrlogin.UName && Convert.ToString(dt.rows(0)("1"))=usrlogin.UPassword) { ViewBag.Status = " Login successfully."; } else { ViewBag.Status = "Incorrect user name and password."; } return View(usrlogin); } Public static DataTable Ulogin() { DataTable dt =new DataTable(); dt=fetch data from database return dt; } Please use it..

Create Login API in C# ASP.NET VS 2010

Answers (17)