Skip to main content

Login Using ADO.NET MVC

In this article of ASP.NET MVC we will learn about login functionality using ADO.NET so let's start.



Firstly create Model Class,in my case i create class namely called Employee and hit the code:





using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;


namespace SignIn_SignUp_Using_AdoDotNet.Models

{

    public class Employee

    {

        public int id { get; set; }

        public string UserName { get; set; }

        public string UserPassword { get; set; }

    }

}



Then create a controller and hit the code below:


using SignIn_SignUp_Using_AdoDotNet.Repository;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data;

using System.Data.SqlClient;

using System.Web.Mvc;

using System.Web.DynamicData;

using SignIn_SignUp_Using_AdoDotNet.Models;


namespace SignIn_SignUp_Using_AdoDotNet.Controllers

{

    public class HomeController : Controller

    {

        // GET: Home

        public ActionResult Index()

        {

            return View();

        }


        public ActionResult Login()

        {

            return View();

        }

        [HttpPost]

        public ActionResult Login(Employee emp)

        {

          string  strCon = "Data Source=DESKTOP-UTTQQQ1;Initial Catalog=Login;Integrated Security=True";

            SqlConnection con = new SqlConnection(strCon);

            con.Open();

            SqlCommand cmd = new SqlCommand("select * from dboLogin where Username = @username and Password = @password",con);

            cmd.Parameters.AddWithValue("@username", emp.UserName);

            cmd.Parameters.AddWithValue("@password", emp.UserPassword);

            SqlDataReader sdr = cmd.ExecuteReader();

            if (sdr.Read())

            {

                Session["Username"] = emp.UserName.ToString();

                return RedirectToAction("Dashboard");

            }

            else

            {

                ViewBag.msg = "Error";

                return RedirectToAction("Index");

            }

        }


        public ActionResult Dashboard()

        {

            return View();

        }

    }

}






Finally i have two views ( Login and Dashboard) :



Login.cshtml:



@model SignIn_SignUp_Using_AdoDotNet.Models.Employee


@{

    ViewBag.Title = "Login";

}


<h2>Login</h2>


@using (Html.BeginForm())

{

    @Html.AntiForgeryToken()

   

    <div class="form-horizontal">

        <h4>Employee</h4>

        <hr />

        @Html.ValidationSummary(true, "", new { @class = "text-danger" })

        <div class="form-group">

            @Html.LabelFor(model => model.UserName, htmlAttributes: new { @class = "control-label col-md-2" })

            <div class="col-md-10">

                @Html.EditorFor(model => model.UserName, new { htmlAttributes = new { @class = "form-control" } })

                @Html.ValidationMessageFor(model => model.UserName, "", new { @class = "text-danger" })

            </div>

        </div>


        <div class="form-group">

            @Html.LabelFor(model => model.UserPassword, htmlAttributes: new { @class = "control-label col-md-2" })

            <div class="col-md-10">

                @Html.EditorFor(model => model.UserPassword, new { htmlAttributes = new { @class = "form-control" } })

                @Html.ValidationMessageFor(model => model.UserPassword, "", new { @class = "text-danger" })

            </div>

        </div>


        <div class="form-group">

            <div class="col-md-offset-2 col-md-10">

                <input type="submit" value="Create" class="btn btn-default" />

            </div>

        </div>

    </div>

}


<div>

    @Html.ActionLink("Back to List", "Index")

</div>








Dashboard.cshtml :



@{

    ViewBag.Title = "Dashboard";

}


<h2>Dashboard</h2>


@if (Session["Username"]!=null)

{

    <h3>@Session["Username"].ToString()</h3>

}

else

{

@ViewBag.msg

}



Comments

Post a Comment

Popular posts from this blog

CRUD Operation in ASP.NET MVC Using ADO.NET Jquery Ajax

In this article of ASP.NET MVC we will learn about CRUD operation using jquery ajax so let's start. Firstly open visual studio: Go to File => New and Select Project,when you select project then New Project Dialogbox will appear. Select ASP.NET Web Application (.NET Framework) and give a name to your project , as we are building CRUD Operation so our project's name could be CRUD_OPEATION and then select OK. Now you will see a new dialogbox, select Empty Template and MVC folder. After create project you will see a like screen like this: Now go to Models folder and add ADO.NET Entity Data Model and give any name like in my case i give dbEntities and selec OK: After that you will see a dilogbox called Entity Data Model Wizard, select EF Designer from database and select Next: After that a new dilogbox will appear and it will ask a new connection to your sql server, then select New Connection and give server name ( if you want to see your server name then open sql server,it will ...
Post a Comment
Read more

SignIn_SignUp in Asp.net Mvc

Models: SignUp Class: using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations.Schema; using System.Linq; using System.Web; namespace Signin_Signup.Models {     [Table("tbl_account")]     public class SignUp     {         public int id { get; set; }         public string name { get; set; }         public string email { get; set; }         public string password { get; set; }     } } DB Class: using System; using System.Collections.Generic; using System.Data.Entity; using System.Linq; using System.Web; namespace Signin_Signup.Models {     public class db:DbContext     {         public DbSet<SignUp> signups { get; set; }     } } User Controller: using Signin_Signup.Models; using System; using System.Collections.Generic; using System.L...
Post a Comment
Read more

ASP.NET MVC Folder and File Structure

When we create an ASP.NET MVC 5 application, the Visual Studio by default creates the following folders and files for our application. App_Data App_Data folder can contain application data files like LocalDB, .mdf files, xml files and other data related files. App_Start: The App_Start folder of an MVC application is used to contain the class files which are needed to be executed at the time of application starts. The classes like BundleConfig, FilterConfig, RouteConfig, IdentityConfig, etc are stored within this folder. So in the simple word we can say that configuration related class files are stored here.  We will discuss the use of each of these class files in detail in our upcoming articles. Content Content folder contain static files like css, images and icons and MVC 5 application includes bootstrap.min.css, bootstrap.css and site.css by default. Controller Controller folder contain class file. It handles user request and response....
Post a Comment
Read more