Database code<\/h2>\n

<\/div>

create database mvccreate table tbl_products(  id int primary key identity(1,1),  product_name varchar(100),  quantity int)insert into tbl_products values ('rice',100)create procedure get_productsas beginselect * from tbl_productsendgocreate procedure insert_products(@product_name varchar(100),@quantity int)as begininsert into tbl_products values(@product_name,@quantity)endinsert_products 'dhall',50edit_products 1,'salt',50create procedure edit_products(@id int,@product_name varchar(100),@quantity int)as beginupdate tbl_products set product_name=@product_name, quantity=@quantity  where id =@idendcreate procedure delete_products(@id int)as begindelete from tbl_products where id =@idendgocreate procedure get_products_id(@id int)as beginselect * from tbl_products where id=@idend<\/code><\/pre> <\/div>\n
Model Code<\/h2>\n
 
 <\/div> 
using System;using System.Collections.Generic;using System.Linq;using System.Web;namespace ArunDepartmentalStore.Models{    public class tbl_products    {        public int id { get; set; }        public string product_name { get; set; }        public int quantity { get; set; }    }}<\/code><\/pre> <\/div>\n
Controller Code<\/h2>\n
 
 <\/div> 
using ArunDepartmentalStore.Models;using System;using System.Collections.Generic;using System.Data.SqlClient;using System.Linq;using System.Web;using System.Web.Mvc;namespace ArunDepartmentalStore.Controllers{    public class tbl_productsController : Controller    {        string constr = "Data Source=.\\\\sqlexpress;Initial Catalog=mvc;Integrated Security =true";        \/\/ GET: tbl_products        public ActionResult Index()        {            List<tbl_products> tbl_products_obj = new List<tbl_products>();            SqlConnection con = new SqlConnection(constr);            SqlCommand cmd = new SqlCommand("get_products", con);            cmd.CommandType = System.Data.CommandType.StoredProcedure;            con.Open();            SqlDataReader sdr = cmd.ExecuteReader();            while(sdr.Read())            {                tbl_products_obj.Add(new tbl_products                {                    id =  Convert.ToInt32( sdr["id"]),                    product_name = Convert.ToString(sdr["product_name"]),                    quantity = Convert.ToInt32(sdr["quantity"])                }                    );             }            con.Close();             return View(tbl_products_obj);        }        \/\/ GET: tbl_products\/Details\/5        public ActionResult Details(int id,tbl_products tbl_products_obj)        {            SqlConnection con = new SqlConnection(constr);            string query = "get_products_id " + id;            SqlCommand cmd = new SqlCommand(query, con);            con.Open();            SqlDataReader sdr = cmd.ExecuteReader();            while (sdr.Read())            {                tbl_products_obj = new tbl_products                {                    id = Convert.ToInt32(sdr["id"]),                    product_name = Convert.ToString(sdr["product_name"]),                    quantity = Convert.ToInt32(sdr["quantity"])                };            }            con.Close();            return View(tbl_products_obj);        }        \/\/ GET: tbl_products\/Create        public ActionResult Create()        {            return View();        }        \/\/ POST: tbl_products\/Create        [HttpPost]        public ActionResult Create(tbl_products tbl_productobj)        {            try            {                SqlConnection con = new SqlConnection(constr);                string query = "insert_products '" + tbl_productobj.product_name + "'," + tbl_productobj.quantity;                SqlCommand cmd = new SqlCommand(query, con);                                con.Open();                int i = cmd.ExecuteNonQuery();                con.Close();                  return RedirectToAction("Index");            }            catch            {                return View();            }        }        \/\/ GET: tbl_products\/Edit\/5        public ActionResult Edit(int id)        {            return View();        }        \/\/ POST: tbl_products\/Edit\/5        [HttpPost]        public ActionResult Edit(int id, tbl_products tbl_productobj)        {            try            {                SqlConnection con = new SqlConnection(constr);                string query = "edit_products " + id +",'" + tbl_productobj.product_name + "'," + tbl_productobj.quantity;                SqlCommand cmd = new SqlCommand(query, con);                con.Open();                int i = cmd.ExecuteNonQuery();                con.Close();                return RedirectToAction("Index");                             }            catch            {                return View();            }        }        \/\/ GET: tbl_products\/Delete\/5        public ActionResult Delete(int id,tbl_products tbl_products_obj)        {            SqlConnection con = new SqlConnection(constr);            string query = "get_products_id " + id;            SqlCommand cmd = new SqlCommand(query, con);                  con.Open();            SqlDataReader sdr = cmd.ExecuteReader();            while (sdr.Read())            {                tbl_products_obj = new tbl_products                 {                    id = Convert.ToInt32(sdr["id"]),                    product_name = Convert.ToString(sdr["product_name"]),                    quantity = Convert.ToInt32(sdr["quantity"])                } ;            }            con.Close();            return View(tbl_products_obj);                     }        \/\/ POST: tbl_products\/Delete\/5        [HttpPost]        public ActionResult Delete(int id)        {            try            {                SqlConnection con = new SqlConnection(constr);                string query = "delete_products " + id ;                SqlCommand cmd = new SqlCommand(query, con);                con.Open();                int i = cmd.ExecuteNonQuery();                con.Close();                return RedirectToAction("Index");             }            catch            {                return View();            }        }    }}<\/code><\/pre> <\/div>\n
View Code<\/h2>\n
Index.cshtml<\/h4>\n
 
 Index.cshtml<\/span> <\/div> 
@model IEnumerable<ArunDepartmentalStore.Models.tbl_products>@{    ViewBag.Title = "Index";}<h2>Index<\/h2><p>    @Html.ActionLink("Create New", "Create")<\/p><table class="table">    <tr>        <th>            @Html.DisplayNameFor(model => model.product_name)        <\/th>        <th>            @Html.DisplayNameFor(model => model.quantity)        <\/th>        <th><\/th>    <\/tr>@foreach (var item in Model) {    <tr>        <td>            @Html.DisplayFor(modelItem => item.product_name)        <\/td>        <td>            @Html.DisplayFor(modelItem => item.quantity)        <\/td>        <td>            @Html.ActionLink("Edit", "Edit", new { id=item.id }) |            @Html.ActionLink("Details", "Details", new { id=item.id }) |            @Html.ActionLink("Delete", "Delete", new { id=item.id })        <\/td>    <\/tr>}<\/table><\/code><\/pre> <\/div>\n
create.cshtml<\/h4>\n
 
 create.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Create";}<h2>Create<\/h2>@using (Html.BeginForm()) {    @Html.AntiForgeryToken()        <div class="form-horizontal">        <h4>tbl_products<\/h4>        <hr \/>        @Html.ValidationSummary(true, "", new { @class = "text-danger" })        <div class="form-group">            @Html.LabelFor(model => model.product_name, htmlAttributes: new { @class = "control-label col-md-2" })            <div class="col-md-10">                @Html.EditorFor(model => model.product_name, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.product_name, "", new { @class = "text-danger" })            <\/div>        <\/div>        <div class="form-group">            @Html.LabelFor(model => model.quantity, htmlAttributes: new { @class = "control-label col-md-2" })            <div class="col-md-10">                @Html.EditorFor(model => model.quantity, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.quantity, "", 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>@section Scripts {    @Scripts.Render("~\/bundles\/jqueryval")}<\/code><\/pre> <\/div>\n
edit.cshtml<\/h4>\n
 
 edit.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Edit";}<h2>Edit<\/h2>@using (Html.BeginForm()){    @Html.AntiForgeryToken()        <div class="form-horizontal">        <h4>tbl_products<\/h4>        <hr \/>        @Html.ValidationSummary(true, "", new { @class = "text-danger" })        @Html.HiddenFor(model => model.id)        <div class="form-group">            @Html.LabelFor(model => model.product_name, htmlAttributes: new { @class = "control-label col-md-2" })            <div class="col-md-10">                @Html.EditorFor(model => model.product_name, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.product_name, "", new { @class = "text-danger" })            <\/div>        <\/div>        <div class="form-group">            @Html.LabelFor(model => model.quantity, htmlAttributes: new { @class = "control-label col-md-2" })            <div class="col-md-10">                @Html.EditorFor(model => model.quantity, new { htmlAttributes = new { @class = "form-control" } })                @Html.ValidationMessageFor(model => model.quantity, "", new { @class = "text-danger" })            <\/div>        <\/div>        <div class="form-group">            <div class="col-md-offset-2 col-md-10">                <input type="submit" value="Save" class="btn btn-default" \/>            <\/div>        <\/div>    <\/div>}<div>    @Html.ActionLink("Back to List", "Index")<\/div>@section Scripts {    @Scripts.Render("~\/bundles\/jqueryval")}<\/code><\/pre> <\/div>\n
Details.cshtml<\/h4>\n
 
 Details.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Details";}<h2>Details<\/h2><div>    <h4>tbl_products<\/h4>    <hr \/>    <dl class="dl-horizontal">        <dt>            @Html.DisplayNameFor(model => model.product_name)        <\/dt>        <dd>            @Html.DisplayFor(model => model.product_name)        <\/dd>        <dt>            @Html.DisplayNameFor(model => model.quantity)        <\/dt>        <dd>            @Html.DisplayFor(model => model.quantity)        <\/dd>    <\/dl><\/div><p>    @Html.ActionLink("Edit", "Edit", new { id = Model.id }) |    @Html.ActionLink("Back to List", "Index")<\/p><\/code><\/pre> <\/div>\n
Delete.cshtml<\/h4>\n
 
 Delete.cshtml<\/span> <\/div> 
@model ArunDepartmentalStore.Models.tbl_products@{    ViewBag.Title = "Delete";}<h2>Delete<\/h2><h3>Are you sure you want to delete this?<\/h3><div>    <h4>tbl_products<\/h4>    <hr \/>    <dl class="dl-horizontal">        <dt>            @Html.DisplayNameFor(model => model.product_name)        <\/dt>        <dd>            @Html.DisplayFor(model => model.product_name)        <\/dd>        <dt>            @Html.DisplayNameFor(model => model.quantity)        <\/dt>        <dd>            @Html.DisplayFor(model => model.quantity)        <\/dd>    <\/dl>    @using (Html.BeginForm()) {        @Html.AntiForgeryToken()        <div class="form-actions no-color">            <input type="submit" value="Delete" class="btn btn-default" \/> |            @Html.ActionLink("Back to List", "Index")        <\/div>    }<\/div><\/code><\/pre> <\/div>\n","protected":false},"excerpt":{"rendered":"
Database code Model Code Controller Code View Code Index.cshtml create.cshtml edit.cshtml Details.cshtml Delete.cshtml<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[19084],"tags":[19089,19090,19086,19088,19085,19087],"class_list":["post-5073","post","type-post","status-publish","format-standard","hentry","category-csharp","tag-net","tag-net-mvc","tag-asp-mvc","tag-charp-mvc","tag-mvc","tag-mvc-code"],"yoast_head":"\n