I am creating login page using MVC application i am checking value from database but my problem is when i am trying to put wrong input value in textbox the loging page accepting wrong value as well which is not available in databaselogin pagepublic class LoginController Controller TestEntities testEntities new TestEntities GET Login public ActionResult Index return View HttpPost public ActionResult IndexUserLogIn userLogIn if

Hi setwellYou need to add FirstOrDefault after the linqPlease refer below sampleViewHomelth2gtWelcome Session34UserName34lth2gtLoginusing HtmlBeginForm34Index34 34Login34 FormMethodPost lttablegt lttrgt ltth colspan34234 style34textaligncenter34gtLogin Pageltthgt lttrgt lttrgt lttdgtHtmlLabelForm gt mUsernamelttdgt lttdgtHtmlTextBoxForm gt mUsernamelttdgt lttdgtHtmlValidationMessageForm gt mUsername 3434 new class 34Error34 lttdgt lttrgt lttrgt lttdgtHtmlLabelForm gt mPasswordlttdgt lttdgtHtmlTextBoxForm gt mPasswordlttdgt lttdgtHtmlValidationMessageForm gt mPassword 3434new class 34Error34lttdgt lttrgt lttrgt

ASP.Net MVC: Login using UserName and Password

setwell

SOLVED CLOSED ACTIVE ANSWERED
User: setwell
Posted: on Dec 30, 2022 01:04 PM
Forum: ASP.Net MVC
Answer: 1
Views: 7905
Sample Code: Download

I am creating login page using MVC application i am checking value from database, but my problem is when i am trying to put wrong input value in textbox the loging page accepting wrong value as well which is not available in database.

public class LoginController : Controller
{
    TestEntities testEntities = new TestEntities();
 
    // GET: Login
    public ActionResult Index()
    {
        return View();
    }
 
    [HttpPost]
    public ActionResult Index(UserLogIn userLogIn)
    {
        if (ModelState.IsValid == true)
        {
            var credential = testEntities.UserLogIns.Where(model => model.UserName == userLogIn.UserName && model.Password == userLogIn.Password);
 
            if (credential == null)
            {
                ViewBag.LoginError = "Login failed.";
                return View();
            }
            else
            {
                Session["UserName"] = userLogIn.UserName;
                return RedirectToAction("Index", "Home");
            }
        }
 
        return View();
    }
}

@using (Html.BeginForm("Index", "Login", FormMethod.Post))
{
    <table>
        <tr>
            <th colspan="2" style="text-align:center">Login Page</th>
        </tr>
        <tr>
            <td>@Html.LabelFor(m => m.UserName):</td>
            <td>@Html.TextBoxFor(m => m.UserName)</td>
            <td>@Html.ValidationMessageFor(m => m.UserName,"", new { @class = "validationErrorMessage" })</td>
        </tr>
        <tr>
            <td>@Html.LabelFor(m => m.Password):</td>
            <td>@Html.TextBoxFor(m => m.Password)</td>
            <td>@Html.ValidationMessageFor(m => m.Password)</td>
        </tr>
        <tr>
            <th colspan="2" style="text-align:center"><input type="submit" value="Login" /></th>
        </tr>
    </table>
}
 
@ViewBag.LoginError
@ViewBag.LoginSuccess

Home page

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        return View();
    }
}

<body>
    <h2>Welcome @Session["UserName"].</h2>
</body>

SQL database record.

Id UserName Password 1

santosh Santosh@1 2

manish Manish2

PrinceG

0 4

Reply
ANSWER
User: PrinceG
Replied: on Jan 02, 2023 12:03 AM
Modified: on Jan 02, 2023 02:25 AM
Report

Hi setwell,

You need to add FirstOrDefault after the linq.

Please refer below sample.

View

Home

<h2>Welcome @Session["UserName"].</h2>

Login

@using (Html.BeginForm("Index", "Login", FormMethod.Post))
{
    <table>
        <tr>
        <th colspan="2" style="text-align:center">Login Page</th>
        </tr>
        <tr>
            <td>@Html.LabelFor(m => m.Username):</td>
            <td>@Html.TextBoxFor(m => m.Username)</td>
            <td>@Html.ValidationMessageFor(m => m.Username, "", new { @class = "Error" })</td>
        </tr>
        <tr>
            <td>@Html.LabelFor(m => m.Password):</td>
            <td>@Html.TextBoxFor(m => m.Password)</td>
            <td>@Html.ValidationMessageFor(m => m.Password, "",new { @class ="Error"})</td>
        </tr>
        <tr>
            <th colspan="2" style="text-align:center"><input type="submit" value="Login" /></th>
        </tr>
    </table>
}

@ViewBag.LoginError
@ViewBag.LoginSuccess

Controller

Home

public ActionResult Index()
{
    return View();
}

Login

public class LoginController : Controller
{
    LoginDBEntities entities = new LoginDBEntities();
    public ActionResult Index()
    {
        return View();
    }

    [HttpPost]
    public ActionResult Index(User userLogIn)
    {
        if (ModelState.IsValid == true)
        {
            var credential = entities.Users.Where(model => model.Username == userLogIn.Username && model.Password == userLogIn.Password).FirstOrDefault();

            if (credential == null)
            {
                ViewBag.LoginError = "Login Failed.";
                return View();
            }
            else
            {
                Session["UserName"] = userLogIn.Username;
                return RedirectToAction("Index", "Home");
            }
        }
        return View();
    }
}

Screenshot

ASP.Net MVC: Login using UserName and Password

Company

Explore

Follow us

Contact Us