Populate DropDownList with multiple columns from Database in ASP.Net MVC

Ruben123...

SOLVED CLOSED ACTIVE ANSWERED
User: Ruben12345
Posted: on Dec 18, 2018 08:45 PM
Forum: ASP.Net MVC
Answer: 1
Views: 12885
Sample Code: Download

how to fill dropdown start date and end date using two column date time table in mvc.

i want to fill dropdown "from date" that contain periode_start and periode_end at the same time

CREATE TABLE [dbo].[maintenance_truck_dedicated](
	[title_id] [int] IDENTITY(1,1) NOT NULL,
	[title] [varchar](50) NULL,
	[vehicle_type_id] [int] NULL,
	[periode_start] [datetime] NULL,
	[periode_end] [datetime] NULL,
	[created_date] [datetime] NULL,
	[last_update] [datetime] NULL,
	[created_by] [int] NULL,
	[last_update_by] [int] NULL,
	[description] [text] NULL,
 CONSTRAINT [PK_maintain_truck_dedicated] PRIMARY KEY CLUSTERED 
(
	[title_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 5

Reply
ANSWER
User: dharmendr
Replied: on Dec 19, 2018 03:50 AM
Report

Hi Ruben12345,

Check this example. Now please take its reference and correct your code.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Namespaces

using System.Configuration;
using System.Data.SqlClient;

Controller

public class HomeController : Controller
{
    // GET: /Home/
    public ActionResult Index()
    {
        TempData["Dates"] = PopulateDates();
        return View();
    }

    private static List<SelectListItem> PopulateDates()
    {
        List<SelectListItem> dates = new List<SelectListItem>();
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            string query = "SELECT BirthDate, HireDate FROM Employees";
            using (SqlCommand cmd = new SqlCommand(query))
            {
                cmd.Connection = con;
                con.Open();
                using (SqlDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        dates.Add(new SelectListItem
                        {
                            Text = sdr["BirthDate"] + " - " + sdr["HireDate"],
                            Value = sdr["BirthDate"] + " - " + sdr["HireDate"]
                        });
                    }
                }
                con.Close();
            }
        }

        return dates;
    }
}

View

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Index</title>
</head>
<body>
    <div>
        <%= Html.DropDownList("Dates", new SelectList((IEnumerable)TempData["Dates"], "Value", "Text"), "--Select Date--")%>
    </div>
</body>
</html>

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Populate DropDownList with multiple columns from Database in ASP.Net MVC

Company

Explore

Follow us

Contact Us