login page code in mvc3

Login page code using mvc3:-

(1)First create a model like mylogin.cs

public class mylogin

    {

        [Required]

        [StringLength(10)]

        public string UserName { get; set; }

        [Required]

        public string PassWord { get; set; }

    }

(2)Create a  folder like DataAccess and with in it create a cs file like DAL.cs

public class DAL

    {

        static SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["111"].ConnectionString);

        public static bool UserIsValid(string username, string password)

        {

            bool authenticated = false;

            string query = string.Format("select * from[fetchlogin] where UserName ='{0}' and Password ='{1}'", username, password);

            SqlCommand cmd = new SqlCommand(query,con);

            con.Open();

            SqlDataReader sr = cmd.ExecuteReader();

            authenticated = sr.HasRows;

            con.Close();

            return (authenticated);

        }

(3) Create a  controller   with in it write below code:-

public class myloginController : Controller

    {

        //

        // GET: /mylogin/

        public ActionResult Index()

        {

            return View();

        }

        [HttpPost]

        public ActionResult Index(mylogin logit)

        {

            if (ModelState.IsValid)

            {

                if (DataAccess.DAL.UserIsValid(logit.UserName, logit.PassWord))

                {

                    FormsAuthentication.SetAuthCookie(logit.UserName, true);

                    return RedirectToAction("Index", "sanshow");

                }

               

                {

                    ModelState.AddModelError("", "Invalid username or password");

                    // ModelState.AddModelError("", "Invalid username or password");

                }

            }

            return View();

        }

    }

(4)Eventually create a view for this:-

@model sanjibmvcmvc.Models.mylogin

@{

    ViewBag.Title = "Index";

}

<h2>Index</h2>

<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>

<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>

@using (Html.BeginForm()) {

    @Html.ValidationSummary(true)

    <fieldset>

        <legend>mylogin</legend>

        <div class="editor-label">

            @Html.LabelFor(model => model.UserName)

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.UserName)

            @Html.ValidationMessageFor(model => model.UserName)

        </div>

        <div class="editor-label">

            @Html.LabelFor(model => model.PassWord)

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.PassWord)

            @Html.ValidationMessageFor(model => model.PassWord)

        </div>

        <p>

            <input type="submit" value="Create" />

        </p>

    </fieldset>

}

<div>

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

</div>