Bind GridView With Database In MVC 5 In C#

In this tutorial, I’ll show you how to bind GridView using MVC5 C# using Razor. In the previous tutorial I haven’t used any database, but here we will use and then we manually feed some data into our table and bind that data to GridView. So it’s a kind of Binding GridView with database.

Step 1

Open Visual Studio 2010, Go to the New Project - Visual C#, Web, then ASP.NET MVC Web Application and click OK.



Step 2

After Clicking OK, New ASP.NET MVC5 Project window will open and there you have to choose MVC and press OK.



Step 3

After Clicking OK, you will see something like the following image in your Solution Explorer. You need to look out for Model, Controller and View folders that are the main files in MVC, others are too but these are main files.



DATABASE CHAMBER:

Step 4

Right Click on your Project - Add New Item, then SQL Server Database and Add it. Go to your Database that resides in Server Explorer - [Database.mdf], We will create a table - tbl_data, Go to the database.mdf, Table and Add New table. Design your table like the following:



Web.Config File:

In Model

Step 4

Right Click on Models - Add New Item, then Add a Class File [Class.cs] and ame it as Student.cs. Write the following code in Student.cs file.

Student.csAdd another class file to Model name and name it “StudentContext”.

StudentContext.cs In Controller

Step 5

Right Click on Controller, Add Empty Controller, Name it – StudentController.cs. Write the following code and don’t forget to add namespace of model.

1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Web;
5. using System.Web.Mvc;
6. using MVCBindGridView.Models;
8. namespace MVCBindGridView.Controllers
9. {
10. public class StudentController : Controller
11. {
12. // GET: Student
13. public ActionResult Index()
14. {
17. StudentContext stdntcntxt = new StudentContext();
19. var data = stdntcntxt.student;
20. return View(data.ToList());
21. }
22. }
23. }

In View

Step 6

Right click on Index() method and Add View like the following image.



You will see under view that there is a folder named student created and inside that folder get your index.cshtml. Write the following code:

Index.cshtml
OUTPUT CHAMBER:


Hope you like it. Thank you for reading. Have a good day.