NIHAR'S BLOG

Dropdownlist in MVC ASP.Net As per requirement we will develop application .We build simple MVC application based on DropDownlist Controller Section :        public ActionResult Index()         {             ViewData["ques"] = new SelectList(_testEntities.ques, "qno","question");             return View();         } Add View , to inherit database entities. View Section <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">     <h2>Index</h2>         <% using (Html.BeginForm(null, null, FormMethod.Post, new { enctype = "multipart/form-data" }))        {%>                  <div class="display-label">Questions</div>         <%= Html.DropDownList("Questions", (Select...

 ViewResult and ActionResult        ActionResult is an abstract class that can have several subtypes.         ViewResult   - Renders a specifed view to the response stream c# code for :         public ViewResult Result()         {             SHIFT_MAST _shift = new SHIFT_MAST();             _shift.shift_cd = "1";             _shift.shift_id = 2;             _shift.start_time = "8.30";             return View("Result", _shift);         }         public ActionResult ResultAction()         {             SHIFT_MAST _shift = new SHIFT_MAST();             _shift.shift_cd = "1";   ...

Adding serial number based on number of rows displaying. You need to add following to your query or Column Name Syntax : Row_Number() Over (Order By a.emp_mast_id) As emp_mast_id Example  : select Row_Number() Over (Order By a.emp_mast_id) As emp_mast_id, a.emp_name, a.address from Emp_mast a ID   Name   Address 1     Nihar    India 2     sam       UK 3     John      USA