In this article I will explain with an example, how to display (show) DataSets and DataTables in Grid format in View in ASP.Net MVC Razor.
Though it is not a good practice to use DataSets and DataTables as Model in MVC architecture, hence user’s please make a note that this is just an informative article and does not recommend to use DataSets and DataTables in ASP.Net MVC Razor.
Note: For beginners in ASP.Net MVC, please refer my article ASP.Net MVC Hello World Tutorial with Sample Program example.
I have made use of the following table Customers with the schema as follows. CustomerId is an Auto-Increment (Identity) column.
Display (Show) DataSets and DataTables in View in ASP.Net MVC Razor
I have already inserted few records in the table.
Display (Show) DataSets and DataTables in View in ASP.Net MVC Razor
Note: You can download the database table SQL by clicking the download link below.
          Download SQL file
You will need to import the following namespaces.
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
The Controller consists of the Index Action method. Inside this Action method, the records are fetched from the Customers Table using ADO.Net .
The records are inserted into a DataSet using SqlDataAdapter class object. Finally the DataSet is returned to the View.
public class HomeController : Controller
    // GET: Home
    public ActionResult Index()
        DataSet ds = new DataSet();
        string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
            string query = "SELECT * FROM Customers";
            using (SqlCommand cmd = new SqlCommand(query))
                cmd.Connection = con;
                using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
        return View(ds);
Inside the View, the DataSet class is declared as Model for the View. For displaying the records, an HTML Table is used. A loop will be executed over the rows of the DataTable which will generate the HTML Table rows with the Customer records.
@using System.Data
@model DataSet
    Layout = null;
<!DOCTYPE html>
    <meta name="viewport" content="width=device-width"/>
    <table cellpadding="0" cellspacing="0">
        @foreach (DataRow row in Model.Tables[0].Rows)
Display (Show) DataSets and DataTables in View in ASP.Net MVC Razor