using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.ComponentModel.DataAnnotations;
namespace MvcApplication1.Models
{
public class DAL
{
public int id { get; set; }
[Required]
public string Name { get; set; }
public string City { get; set; }
public string Education { get; set; }

public SqlConnection con = new SqlConnection(@”Data Source=(LocalDB)\v11.0;\Database1.mdf;Integrated Security=True”);

public DataSet Binddl(DAL da)
{
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(“select Name from tbl_user“,con);
adp.Fill(ds);
return ds;

}
}
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MvcApplication1.Models;
using System.Data;
using System.Data.SqlClient;
namespace MvcApplication1.Controllers
{
public class ABCController : Controller
{
//
// GET: /ABC/

public ActionResult Index()
{
return View();
}

public ActionResult ddl(DAL da)
{
DataSet ds = da.Binddl(da);
ViewBag.fname = ds.Tables[0];
List<SelectListItem> lst = new List<SelectListItem>();
foreach (System.Data.DataRow dr in ViewBag.fname.Rows)
{
lst.Add(new SelectListItem { Text = @dr[“Name“].ToString(), Value = @dr[“Name“].ToString() });
}
ViewBag.Name = lst;
return View();
}

}

}

@model MvcApplication1.Models.DAL@{
ViewBag.Title = “ddl“;
}

@Html.DropDownList(“Name“, ViewBag.Name as SelectList)

1. Auto Refresh Partial View in ASP.NET MVC
2. What is ASP.NET Core
3. Difference between TempData keep() And Peek() in Asp.Net MVC
4. Difference between viewbag,viewdata and tempdata in asp.net mvc
5. ASP.NET MVC With AngularJS
6. Retrieving Data Using Form Collection and Inserting Into ASP.Net MVC
7. MVC CRUD Operations Using Entity Framework
8. Search Functionality in ASP.NET MVC
9. How to create a User Registration page using asp.net mvc
10. Store Multiple Checkbox state from cookie using Jquery
11. Cascading Dropdownlist using Ajax in Asp.Net Mvc with city state country
12. Insert, Update, Delete In GridView Using ASP.Net C#
13. Binding Dropdownlist With Database In Asp.Net MVC
14. Search and Filter data in Gridview using Asp.net MVC
15. Select Insert, Update And Delete With ASP.NET MVC
16. Display Data in GridView Using Asp.net MVC
17. Validation in ASP.NET MVC Razor view
18. CRUD Operation Using 3-Tier Architecture In ASP.NET
19. How to get Connection String from Web.Config in Asp.Net C#
20. Login page using 3-Tier Architecture in ASP.Net
21. Asp.Net Image Upload in 3-Tier Architecture and store in sql database