Retrieving Data Using Form Collection and Inserting Into ASP.Net MVC 3

Priti Ranjan Dash
9y
104.7k
0
2

100

Article

Introduction

There are three ways to pass a value or data from a view to an action.

Parameterized Query.
Form Data.
Model Binding.

The data that is passed

A Form Collection is the data that is passed in a form submission when we use the HTTP POST Method.

What we will do in this application.
We will learn retrieving the data by using Form Collection.
For all this operation we will use the EntityFramework.

The following database script is available in the attached file.

create table tbl_FormCollectionUse
(
ID int identity primary key,
Name varchar(50),
Mobile bigint,
EmailID varchar(100),
Address varchar(100)
)

Start Visual Studio 2010 then Start a New MVC 3 (With Razor View Engine).

Add a New Controller to the project named “FormCollection”.

Steps

Steps

FormCollectionController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcApplication3.Controllers
{
public class FormCollectionController : Controller
{
string _Name, _EmailID, _Address;
long _MobileN0;
//
//
// GET: /FormCollection/
public ActionResult Index()
{
return View();
}
}
}

Add a View to the Index() Action method.

Index.cshtml

@{
ViewBag.Title = "Index";
}
<h2>Index</h2>
<h6></h6>
<h6> I will Retrieve data through the Form Collection and Insert it to the database.</h6>
<h6>@Html.ActionLink("New Record", "NewRecord", "FormCollection")</h6>

Add a new Action Method as in the following:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcApplication3.Controllers
{
public class FormCollectionController : Controller
{
string _Name, _EmailID, _Address;
long _MobileN0;
//
//
// GET: /FormCollection/
public ActionResult Index()
{
return View();
}
public ActionResult NewRecord()
{
return View();
}
}
}

Add a View to the Action method as in the following:

Design The View Depending on our requirements

NewRecord.cshtml

@{
ViewBag.Title = "NewRecord";
}
<h2>NewRecord</h2>
<h6>@Html.ActionLink("Go Back", "Index", "FormCollection")</h6>
@using (@Html.BeginForm("Insert", "FormCollection", FormMethod.Post))
{
<table>
<tr>
<td>@Html.Label("Name")</td><td>:</td><td>@Html.TextBox("TxtName")</td>
</tr>
<tr>
<td>@Html.Label("Mobile No")</td><td>:</td><td>@Html.TextBox("Mobile")</td>
</tr>
<tr>
<td>@Html.Label("EmailID")</td><td>:</td><td>@Html.TextBox("TxtEmailID")</td>
</tr>
<tr>
<td>@Html.Label("Address")</td><td>:</td><td>@Html.TextBox("TxtAddress")</td>
</tr>
<tr>
<td>@Html.Label("Save Your Details")</td><td>:</td><td><input type="submit" value="Submit" /></td>
</tr>
<tr>
<td>@Html.Label("Reset Your Details")</td><td>:</td><td><input type="reset" value="Reset" /></td>
</tr>
</table>
}

Explanation To The Design

Then add a new Action Method to the Controller as in the following:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcApplication3.Controllers
{
public class FormCollectionController : Controller
{
string _Name, _EmailID, _Address;
long _MobileN0;
//
//
// GET: /FormCollection/
public ActionResult Index()
{
return View();
}
public ActionResult NewRecord()
{
return View();
}
public ActionResult Insert(FormCollection Fc)
{
return View();
}
}
}

Notice: The new Action Method is declared with a FormCollection Parameter.

Then add a View for the Insert Action as in the following:method

Insert.cshtml

@{
ViewBag.Title = "Insert";
}
<h2>Insert</h2>
<h6>@Html.ActionLink("Go Back", "Index", "FormCollection")</h6>
<h6>@ViewBag.Msg</h6>

Create the table if not created and add it to the Entity Framework Model Designer as in the following:

create table tbl_FormCollectionUse
(
ID int identity primary key,
Name varchar(50),
Mobile bigint,
EmailID varchar(100),
Address varchar(100)
)

The following shows how to add a table to the (EntityFramework Designer) Model.edmx file.

At the Model.edmx select Update Model from Database -> Update Wizard then select the Table Name then click Finish.

Modify the code at Insert the Action method and retrieve and save that data to the database.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcApplication3.Controllers
{
public class FormCollectionController : Controller
{
string _Name, _EmailID, _Address;
long _MobileN0;
//
//
// GET: /FormCollection/
public ActionResult Index()
{
return View();
}
public ActionResult NewRecord()
{
return View();
}
public ActionResult Insert(FormCollection Fc)
{
using (MVC_PracticeEntities objContext = new MVC_PracticeEntities())
{
tbl_FormCollectionUse Tbl = new tbl_FormCollectionUse();
//
Tbl.Name = Fc["TxtName"].ToString();
Tbl.Mobile = Convert.ToInt64(Fc["Mobile"]);
Tbl.EmailID = Fc["TxtEmailID"].ToString();
Tbl.Address = Fc["TxtAddress"].ToString();
//
objContext.AddTotbl_FormCollectionUse(Tbl);
//
int i = objContext.SaveChanges();
if (i > 0)
{
ViewBag.Msg = "Data Saved Suuceessfully.";
}
}
//_Name=F
return View();
}
}
}

Run the application and test it.

Click on New Record.

Click on Submit.

Ad some more data and watch the DB Table.

I am providing all the code and the scripts again.

Index.cshtml

@{
ViewBag.Title = "Index";
}
<h2>Index</h2>
<h6></h6>
<h6> I will Retrieve data through the Form Collection and Insert it to the database.</h6>
<h6>@Html.ActionLink("New Record", "NewRecord", "FormCollection")</h6>

NewRecord.cshtml

@{
ViewBag.Title = "NewRecord";
}
<h2>NewRecord</h2>
<h6>@Html.ActionLink("Go Back", "Index", "FormCollection")</h6>
@using (@Html.BeginForm("Insert", "FormCollection", FormMethod.Post))
{
<table>
<tr>
<td>@Html.Label("Name")</td><td>:</td><td>@Html.TextBox("TxtName")</td>
</tr>
<tr>
<td>@Html.Label("Mobile No")</td><td>:</td><td>@Html.TextBox("Mobile")</td>
</tr>
<tr>
<td>@Html.Label("EmailID")</td><td>:</td><td>@Html.TextBox("TxtEmailID")</td>
</tr>
<tr>
<td>@Html.Label("Address")</td><td>:</td><td>@Html.TextBox("TxtAddress")</td>
</tr>
<tr>
<td>@Html.Label("Save Your Details")</td><td>:</td><td><input type="submit" value="Submit" /></td>
</tr>
<tr>
<td>@Html.Label("Reset Your Details")</td><td>:</td><td><input type="reset" value="Reset" /></td>
</tr>
</table>
}