How to Choose Business Intelligence Reporting Tool?
You know, there are about 426 BI reporting tools available each with unique features. But there isn't a clear-cut answer to which BI reporting tool is the absolute best. It actually...
Kapil Panchal - June 30, 2021
Listening is fun too.
Straighten your back and cherish with coffee - PLAY !
Form collection is used to retrieve input elements from the controller action method. Form collection class automatically receives the data form value in controller methods in the form of key/value pair. Key and value pairs are accessed using the key name and index value.
Here in this article, I will show you how to use form collection and how we can use form collection class.
Here I will create the view to enter data into a database table using the form collection class available in ASP.NET MVC.
Open Visual Studio or any editor and create a new Asp.net Web Application (.NET Framework) application and provide the appropriate name.
[Fig:- Create project]
STEP 2Select MVC Option or either use the Empty template as per your choice.
[Fig:- MVC Application]
STEP 3Now, we need to enter the data model into our application. Right-click on a model folder and then click Add. Select Ado.NET Entity Data Model. If the Data model does not show this way you can click on a new item and select ADO.NET Entity Data Model.
[Fig:- ADO.NET Entity Data Model]
Give the name for the Entity model
[Fig:- ADO.NET Entity Data Model Name]
After Clicking OK. This wizard will open select EF Designer from Database. Here I will use the database first approach so I will choose EF Designer first model that you can use any model according to your need but the above step is different from code first and models first approach.
[Fig:- EF Designer First model]
After clicking Next, a window will appear. Click New Connection. Another window will appear to add your server name and select your database and click OK.
[Fig:- New Connection]
Now a new connection will be added. Click OK.
[Fig:- New Connection string added ]
After clicking on Finish your table will be added and the following classes will be added to your model folder.
[Fig:- Model folder]
STEP 4Now we need to add a controller. Right-click on the controller folder and select MVC Empty controller click on Add.
After clicking in Add, another window will appear. Provide the name of the controller and click Add. Your Controller will be added to the controller folder.
[Fig:- MVC Empty Controller]
The form collection class automatically receives the form value in the controller action method in the form of key and value pair. Keys and value pairs can be accessed using a name or index.
We can use the loop to access each key and its value sent to the server. Let's add the following method.
using System; using System.Collections.Generic; using System. Linq; using System. Web; using System.Web.Mvc; using FromCollectionDemo.Models; namespace FromCollectionDemo.Controllers { public class EmployeeController: Controller { Trainee2021Entities db = new Trainee2021Entities(); // GET: Employee public ActionResult Index() { var employee = db.employees.ToList(); return View(employee); } public ActionResult Create() { return View(); } [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create(FormCollection formCollection) { if (ModelState.IsValid) { foreach (string key in formCollection.AllKeys) { Response.Write("Key=" + key + " "); Response.Write("Value=" + formCollection[key]); Response.Write(" "); } } return View(); } }
If you run this code inside the EmployeeController you will get the following output on your screen.
[Fig:- key Value pair]
The above code does not insert the data in the database it simply displays our data in key-value pair. But I want to enter data into the database so I want to change my code. Here is my full code for EmployeeController
EmployeeControllerusing System; using System.Collections.Generic; using System. Linq; using System. Web; using System.Web.Mvc; using FromCollectionDemo.Models; namespace FromCollectionDemo.Controllers { public class EmployeeController: Controller { Trainee2021Entities db = new Trainee2021Entities(); public ActionResult Index() { var employee = db.employees.ToList(); return View(employee); } public ActionResult Create() { return View(); } [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create(FormCollection formCollection) { if (ModelState.IsValid) { employee emp = new employee(); emp.Firstname = formCollection["Firstname"]; emp.Lastname = formCollection["Lastname"]; emp.Gender = formCollection["Gender"]; emp.Salary = Convert.ToInt32(formCollection["Salary"]); emp.State = formCollection["State"]; emp.Address = formCollection["Address"]; db.employees.Add(emp); db.SaveChanges(); return RedirectToAction("Index"); } return View(); } } }
Right click on the Index method in Employee controller. Click on Add View the window will appear select List template and model class.
After clicking the Add. it will create an Index view page on the Index page where we get a list of records from the database.]
[Fig:- Index view]
In the same way, we can create a view for Create method but we select Create Template it will generate the default code.
Run the Create. Cshtml, it gives the following output
[Fig:- Create Page]
For Gender it has a radio button and also for State is ideal for a drop-down list instead of a text box. To achieve this functionality, I change my code. Here is my full code for Create View.
Now use the code and you will get the next result.
Create.cshtml@model FromCollectionDemo.Models.employee @{ ViewBag.Title = "Create"; }Create
@using (Html.BeginForm()) { @Html.AntiForgeryToken()}employee
@Html.LabelFor(model => model.Firstname, htmlAttributes: new { @class = "control-label col-md-2" })@Html.EditorFor(model => model.Firstname, new { htmlAttributes = new { @class = "form-control" } })@Html.LabelFor(model => model.Lastname, htmlAttributes: new { @class = "control-label col-md-2" })@Html.EditorFor(model => model.Lastname, new { htmlAttributes = new { @class = "form-control" } })@Html.LabelFor(model => model.Salary, htmlAttributes: new { @class = "control-label col-md-2" })@Html.EditorFor(model => model.Salary, new { htmlAttributes = new { @class = "form-control" } })@Html.LabelFor(model => model.Gender, htmlAttributes: new { @class = "control-label col-md-2" })Male @Html.RadioButtonFor(model => model.Gender, "Male") Female @Html.RadioButtonFor(model => model.Gender, "Female")@Html.LabelFor(model => model.State, htmlAttributes: new { @class = "control-label col-md-2" })@Html.DropDownList("State" , new List{ new SelectListItem{Text = "Gujarat" , Value="Gujarat"}, new SelectListItem { Text = "Mumbai" , Value ="Mumbai"}, new SelectListItem{ Text ="Delhi" ,Value = "Delhi"}, new SelectListItem{ Text ="Hydrabad" ,Value = "Hydrabad"} },"select State" ,new {@class ="form-control"}) @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2" })@Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })@Html.ActionLink("Back to List", "Index")@section Scripts { @Scripts.Render("~/bundles/jqueryval") }
Now run the code and you will get the following output.
[Fig:- Index Page]
In this article, we have learned Form Collection automatically retrieves input element value from a controller action method. Use the form collection class to retrieve input element data.
Build Your Agile Team
You know, there are about 426 BI reporting tools available each with unique features. But there isn't a clear-cut answer to which BI reporting tool is the absolute best. It actually...
It’s difficult to believe, but there are about 426 Business Intelligence tools available! And the leaders in this field are Tableau, holding a 12.37% market share, and Power BI, which...
Choosing between Databricks and Azure Synapse Analytics can feel like picking between two powerful data analytics tools, each with its own strengths and unique features. Azure Synapse...