Bind table and list using ViewBag in ASP.NET Core with Visual Studio Code

April 15 2020 by Admin

In this article, we will explore how to bind table and list using ViewBag in ASP.NET Core with an example in Visual Studio Code.

In this article, we will explore how to bind table and list using ViewBag in ASP.NET Core with an example in Visual Studio Code. We have used the razor view engine and bound the table and list from the database using ADO.net. It's a very simple way for table and list binding.

In this example, we have taken customers' data for binding a table. You can see the below example code. Visual Studio Code is a lightweight but powerful source code editor. It is a fully open-source and cross-platform framework available on Windows, Linux, and Mac.

Step -1

Open Visual Studio Code.

Bind Table and List using ViewModel in ASP.NET Core with Visual Studio Code

Step -2

Click on the file in the menu and select Open Folder. We are creating a folder for project(SampleCode) and select created folder's name.

Step -3

Go to Terminal and Select New Terminal in the menu. In the terminal window, type dotnet new mvc .

Step -4

Build and Run the MVC Application. In the terminal window, type dotnet Build and dotnet run .

Required Namespaces

We will need to use the following namespaces.

using Microsoft.AspNetCore.Mvc;

using SampleCode.Models;

using Microsoft.Extensions.Configuration;

using System.IO;

using System.Data.SqlClient;

Views

We have provided razor view html below.

@model SampleCode.Models.Customers

ViewData["Title"] = "Home Page";

}

<html>

<head>

<title>

Bind Table and List using ViewModel in ASP.NET Core with Visual Studio Code.

</title>

</head>

<body>

<tr>

<th>

@Html.DisplayNameFor(model => model.CustId)

</th>

<th>

@Html.DisplayNameFor(model => model.Firstname)

</th>

<th>

@Html.DisplayNameFor(model => model.LastName)

</th>

<th>

@Html.DisplayNameFor(model => model.Role)

</th>

</tr>

@foreach (var item in ViewBag.Customers)

{

<tr>

<td>

@item.CustId

</td>

<td>

@item.Firstname

</td>

<td>

@item.LastName

</td>

<td>

@item.Role

</td>

</tr>

}

</table>

</div>

</body>

</html>

Models

public class Customers

{

public Int32 CustId { get; set; }

public string Firstname { get; set; }

public string LastName { get; set; }

public string Role { get; set; }

}

HomeController

public class HomeController : Controller

{

public IConfigurationRoot GetConnection()

{

var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appSettings.json").Build();

return builder;

}

public IActionResult Index()

{

ViewBag.Customers=GetCustomerList();

return View();

}

public List<Customers> GetCustomerList()

{

var connection = GetConnection().GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;

SqlConnection con = new SqlConnection(connection);

SqlCommand cmd = new SqlCommand("Select * From Customers", con);

con.Open();

SqlDataReader idr = cmd.ExecuteReader();

List<Customers> customers = new List<Customers>();

if (idr.HasRows)

{

while (idr.Read())

{

customers.Add(new Customers

{

CustId = Convert.ToInt32(idr["customerId"]),

Firstname = Convert.ToString(idr["Firstname"]),

LastName = Convert.ToString(idr["LastName"]),

Role = Convert.ToString(idr["Role"])

});

}

con.Close();

return customers;

}

Output

Populate DropDownList in ASP.NET Core Using Visual Studio Code

Download

Home > MVC > Bind table and list using ViewBag in ASP.NET Core with Visual Studio Code

Bind table and list using ViewBag in ASP.NET Core with Visual Studio Code

Related Articles

How to use grid in MVC using GridMvc

4/29/2019 11:20:00 AM By Admin

16204 Views

How to use Filterable, Sortable and WithPaging in MVC using GridMvc

4/29/2019 10:39:00 PM By Admin

4026 Views

How to add GridMvc DLL in MVC.

5/1/2019 11:13:00 AM By Admin

4772 Views

How to create the crud operations such as Insert, Update and Delete in MVC using C#

6/18/2019 11:50:00 AM By Admin

4729 Views

How to insert update delete data from database in MVC using C#

6/18/2019 8:58:00 PM By Admin

4221 Views

How to bind multiple Dropdownlist in MVC using C#

7/2/2019 5:30:00 AM By Admin

8652 Views

How to bind Dropdownlist in MVC from the database

7/2/2019 11:04:00 AM By Admin

19342 Views

How to bind the Checkboxlist and get selected value in MVC

7/21/2019 11:52:00 AM By Admin

7071 Views

How to Fileupload and save image in binary format in MVC

8/24/2019 4:20:00 AM By Admin

8500 Views

How to save image in database and display into Views in MVC

8/24/2019 5:05:00 AM By Admin

11344 Views

Comments

Leave a Reply

Comment:^*

Please your Comment !

Email ID:^*

Enter Your Email Id ! Enter Your Validate Email Id !

Name:^*

Enter your Name !

RECENT POSTS

Technology

Information

Tags

Email Alerts

Home > MVC > Bind table and list using ViewBag in ASP.NET Core with Visual Studio Code

Related Articles

How to use grid in MVC using GridMvc 4/29/2019 11:20:00 AM By Admin 16204 Views

How to use Filterable, Sortable and WithPaging in MVC using GridMvc 4/29/2019 10:39:00 PM By Admin 4026 Views

How to add GridMvc DLL in MVC. 5/1/2019 11:13:00 AM By Admin 4772 Views

How to create the crud operations such as Insert, Update and Delete in MVC using C# 6/18/2019 11:50:00 AM By Admin 4729 Views

How to insert update delete data from database in MVC using C# 6/18/2019 8:58:00 PM By Admin 4221 Views

How to bind multiple Dropdownlist in MVC using C# 7/2/2019 5:30:00 AM By Admin 8652 Views

How to bind Dropdownlist in MVC from the database 7/2/2019 11:04:00 AM By Admin 19342 Views

How to bind the Checkboxlist and get selected value in MVC 7/21/2019 11:52:00 AM By Admin 7071 Views

How to Fileupload and save image in binary format in MVC 8/24/2019 4:20:00 AM By Admin 8500 Views

How to save image in database and display into Views in MVC 8/24/2019 5:05:00 AM By Admin 11344 Views

Comments

Leave a Reply Comment:* Please your Comment ! Email ID:* Enter Your Email Id ! Enter Your Validate Email Id ! Name:* Enter your Name !

RECENT POSTS

Technology

Information

Tags

Email Alerts

How to use grid in MVC using GridMvc

4/29/2019 11:20:00 AM By Admin

16204 Views

How to use Filterable, Sortable and WithPaging in MVC using GridMvc

4/29/2019 10:39:00 PM By Admin

4026 Views

How to add GridMvc DLL in MVC.

5/1/2019 11:13:00 AM By Admin

4772 Views

How to create the crud operations such as Insert, Update and Delete in MVC using C#

6/18/2019 11:50:00 AM By Admin

4729 Views

How to insert update delete data from database in MVC using C#

6/18/2019 8:58:00 PM By Admin

4221 Views

How to bind multiple Dropdownlist in MVC using C#

7/2/2019 5:30:00 AM By Admin

8652 Views

How to bind Dropdownlist in MVC from the database

7/2/2019 11:04:00 AM By Admin

19342 Views

How to bind the Checkboxlist and get selected value in MVC

7/21/2019 11:52:00 AM By Admin

7071 Views

How to Fileupload and save image in binary format in MVC

8/24/2019 4:20:00 AM By Admin

8500 Views

How to save image in database and display into Views in MVC

8/24/2019 5:05:00 AM By Admin

11344 Views

Leave a Reply

Comment:^*

Please your Comment !

Email ID:^*

Enter Your Email Id ! Enter Your Validate Email Id !

Name:^*

Enter your Name !