USE [master]
GO
/****** Object:  Database [ACTOR]    Script Date: 7/11/2023 8:01:25 PM ******/
CREATE DATABASE [ACTOR]
GO
USE [ACTOR]
GO
/****** Object:  Table [dbo].[SalaryOfActor]    Script Date: 7/11/2023 8:01:25 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SalaryOfActor](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[NAME] [nvarchar](100) NULL,
	[Salary] [money] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[SalaryOfActor] ON 

INSERT [dbo].[SalaryOfActor] ([Id], [NAME], [Salary]) VALUES (1, N'Vương Vũ Tiệp', 100000.0000)
INSERT [dbo].[SalaryOfActor] ([Id], [NAME], [Salary]) VALUES (2, N'Maragret Wang', 100000.0000)
INSERT [dbo].[SalaryOfActor] ([Id], [NAME], [Salary]) VALUES (3, N'Phương Sổ Chân', 50000.0000)
INSERT [dbo].[SalaryOfActor] ([Id], [NAME], [Salary]) VALUES (4, N'Tống Đạt Dân', 40000.0000)
SET IDENTITY_INSERT [dbo].[SalaryOfActor] OFF
GO
USE [master]
GO
ALTER DATABASE [ACTOR] SET  READ_WRITE 
GO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using DislayListFromSQLandSearchInList.Models;
namespace DislayListFromSQLandSearchInList.Controllers
{
    public class ActorController : Controller
    {
        // GET: Actor
        public ActionResult Index(string Search="")
        {
            ACTOREntities1 db = new ACTOREntities1();
            List<SalaryOfActor> salary = db.SalaryOfActors.Where(p=>p.NAME.Contains(Search)).ToList();
            ViewBag.Search = Search;
            return View(salary);
        }
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace DislayListFromSQLandSearchInList.Controllers
{
    public class HomeController : Controller
    {
        // GET: Home
        public ActionResult Index()
        {
            return View();
        }
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

@model List<DislayListFromSQLandSearchInList.Models.SalaryOfActor>
@{
    ViewBag.Title = "Hãng phim Dân Thị";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>Danh sách diễn viên và lương</h2>
<form class="d-flex flex-row align-items-center flex-wrap" action="/Actor/Index">
    <label for="Search" class="mx-2 my-1"></label>
    <input type="Search" class="form-control w-auto" id="Search" name="Search" value="@ViewBag.Search" placeholder="Nhập tên diễn viên cần tìm" />
    <button type="submit" class="btn btn-primary mx-2">Tìm</button>
</form>
<table class="table">
    <tr>
        <th>STT</th>
        <th>Tên diễn viên</th>
        <th>Lương</th>
    </tr>
    @foreach (var item in Model)
    {
        <tr>
            <td>@item.Id</td>
            <td>@item.NAME</td>
            <td>@item.Salary.Value.ToString("c")</td>
        </tr>
    }
</table>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>TRANG CHỦ</h2>

1
2
3
4
5
6
7
8
9