---
title: "Passing multiple dropdown list values from view to controller and saving into database."
description: "For doing this task we use data first approach entity framework. In this first we create database and then generate model on basis of database First"
author: "Jonas Stuart"
published: 2017-02-04
updated: 2018-03-17
canonical: https://www.mindstick.com/blog/11290/passing-multiple-dropdown-list-values-from-view-to-controller-and-saving-into-database
category: "asp.net mvc"
tags: ["mvc"]
reading_time: 3 minutes
---
# Passing multiple dropdown list values from view to controller and saving into database.
For doing this task we use [data first approach](https://www.mindstick.com/forum/34493/call-stored-procedures-with-entity-framework-6-data-first-approach-in-asp-dot-net-mvc-4) [entity framework](https://www.mindstick.com/articles/1566/crud-operations-using-entity-framework-code-first-approach). In this first we create [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) and then generate model on basis of database.\
**First we create database and table**
**Countrylist table for first [dropdown](https://www.mindstick.com/articles/263/ajax-toolkit-dropdownextender-in-asp-dot-net)**
```
CREATE TABLE [dbo].[Country]( [Id] [int] IDENTITY(1,1) primary key NOT NULL, [Country] [varchar](50) NULL, ) DistrictList tale CREATE TABLE [dbo].[District]( [Id] [int] IDENTITY(1,1) primary key NOT NULL, [District] [varchar](50) NULL, )And Statelist table CREATE TABLE [dbo].[State]( [Id] [int] IDENTITY(1,1) primary key NOT NULL, [State] [varchar](50) NULL, )
```
## And Registrationform table
```
CREATE TABLE [dbo].[Registration]( [Id] [int] IDENTITY(1,1) primary key NOT NULL, [Name] [varchar](50) NULL, [Country] [varchar](50) NULL, [State] [varchar](50) NULL, [District] [varchar](50) NULL, [Address] [varchar](50) NULL,)
```
**Now add New Project and Right Click on the Models folder and select [Ado.Net](https://www.mindstick.com/articles/804/connection-pooling-in-ado-dot-net) [Entity Data Model](https://www.mindstick.com/articles/594/ado-dot-net-entity-data-model-in-wpf)**
\
**And the click generate From Database**
\
**And next and then give [connection](https://www.mindstick.com/articles/13012/what-makes-ethernet-connection-better-than-wifi) information and select your database.**
\
**Then choose tables and then finish.**
In the next step we will create Home Controller for adding controller right click on the controllers folder and go to add and then click controller then a pop up will be appear from here you can change you can give your controller name \
\
**In the [controller](https://www.mindstick.com/blog/273/passing-values-from-controller-to-view-in-asp-dot-net-mvc) copy the following code.**
```
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Mvc;using System.Data; using MvcApplication4.Models; namespace
MvcApplication4.Controllers{ public class HomeController : Controller { // // GET: /Home/ public ActionResult Index() { var context = new DropdownEntities(); ViewBag.country = context.Countries; ViewBag.state = context.States; ViewBag.district = context.Districts; return View(); } [HttpPost] public ActionResult Add(Registration Model) { using(var context=new DropdownEntities()) {
context.Registrations.Add(Model); context.SaveChanges(); } var context1 = new DropdownEntities(); ViewBag.country = context1.Countries; ViewBag.state = context1.States; ViewBag.district =context1.Districts; return View("Index"); } }}
```
## And in the view
```
@model MvcApplication4.Models.Registration@{ Layout = null;} Index