---
title: "How to pass multiple dropdown list values from view to controller and saving into a database?"
description: "How to pass multiple dropdown list values from view to controller and saving into a database?"
author: "Ailsa Singh"
published: 2017-05-04
updated: 2017-05-04
canonical: https://www.mindstick.com/forum/34288/how-to-pass-multiple-dropdown-list-values-from-view-to-controller-and-saving-into-a-database
category: "database"
tags: ["sql"]
reading_time: 3 minutes
---
# How to pass multiple dropdown list values from view to controller and saving into a database?
I am having difficulty in passing [multiple](https://www.mindstick.com/blog/12797/iowa-is-expected-to-see-heavy-growth-in-multiple-sectors) [dropdown list](https://www.mindstick.com/forum/760/dropdown-list-open-hide-behind-another-dropdown-list-on-ie-7) [values](https://www.mindstick.com/forum/327/sum-textbox-values) from [view to controller](https://www.mindstick.com/forum/34314/post-data-from-view-to-controller-using-ajax) and [saving](https://www.mindstick.com/blog/11865/guide-to-saving-15-for-retirement) [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) into a database. Please help me.Thanks in advance.
## Replies
### Reply by Manish Kumar
\
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 table
```
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 Entity Data Model
\
\
\
And the click generate From Database
\
\
\
\
And next and then give connection 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](https://yourviews.mindstick.com/view/84701/layoffs-in-google-india-2023-view)
\
```
@model MvcApplication4.Models.Registration@{
Layout = null;}
Index