July 02 2019 by Admin
In this article, we have described how to bind Dropdownlist in MVC from the database with an example and a sample code.
In this article, we have described how to bind Dropdownlist in MVC from the database with an example and a sample code.
We have used the razor view engine and binded the Dropdownlist from the database using ADO.net. It's a very simple way for Dropdownlist binding. In this example, we have taken employees and customers data for binding a Dropdownlist. You can see the below example code .
Required Namespaces
We will need to use the following namespaces.
using Dropddownlist_Project.Models;
using System.Configuration;
using System.Data.SqlClient;
Views
We have provided razor view html below.
@model Dropddownlist_Project.Models.Dropdownlist
@{
Layout = null;
}
How to bind mutiple Dropdownlist in mvc using C# Example
Customer Name:
@Html.DropDownListFor[model => model.custlist, new SelectList[Model.custlist, "custId", "custName"], new { @class = "form-control" }]
Employee Name :
@Html.DropDownListFor[model => model.emplist, new SelectList[Model.emplist, "Empid", "EmpName"], new { @class = "form-control" }]
Model
In this model we have two child classes for dropdownlist binding. you can use your existing class for this activity.
public class Dropdownlist
{
public Listemplist { get; set; }
public Listcustlist { get; set; }
}
public class Employee_list
{
public int Empid { get; set; }
public string EmpName { get; set; }
}
public class Customer_list
{
public int custId { get; set; }
public string custName { get; set; }
}
Controller
We have created DropDownlist name of controller.
public class DropDownlistController : Controller
{
// GET: DropDownlist
public ActionResult DropDownControl[]
{
Dropdownlist multi_Dropdownlist = new Dropdownlist
{
custlist = GetCustomerList[],
emplist = GetEmployeeList[]
};
return View[multi_Dropdownlist];
}
public ListGetCustomerList[]
{
var connection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString[];
SqlConnection con = new SqlConnection[connection];
SqlCommand cmd = new SqlCommand["Select customerId,FirstName as Name From Customers", con];
con.Open[];
SqlDataReader idr = cmd.ExecuteReader[];
Listcustomers = new List[];
if [idr.HasRows]
{
while [idr.Read[]]
{
customers.Add[new Customer_list
{
custId = Convert.ToInt32[idr["customerId"]],
custName = Convert.ToString[idr["Name"]],
}];
}
}
con.Close[];
return customers;
}
public ListGetEmployeeList[]
{
var connection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString[];
SqlConnection con = new SqlConnection[connection];
SqlCommand cmd = new SqlCommand["Select * From Employees", con];
con.Open[];
SqlDataReader idr = cmd.ExecuteReader[];
ListEmployees = new List[];
if [idr.HasRows]
{
while [idr.Read[]]
{
Employees.Add[new Employee_list
{
Empid = Convert.ToInt32[idr["EmpoyeeId"]],
EmpName = Convert.ToString[idr["EmpName"]],
}];
}
}
con.Close[];
return Employees;
}
}
Screenshot
Download
Note: All contents are copyright of their authors.