Quickly listing records in Grid in ASP.NET MVC

Sheonarayan
Posted by in ASP.NET MVC category on for Intermediate level | Points: 250 | Views : 4380 red flag
Rating: 5 out of 5  
 2 vote(s)

In this article, we are going to learn how to quickly list the data from the database into Grid in ASP.NET MVC.
Recommendation
Read Creating a custom route handler in ASP.NET MVC before this article.

Introduction


We all know the benefit and beauty of GridView in ASP.NET Web Form. This is the best data control in ASP.NET MVC to quickly list the data from the database without specifying columns, table format etc. This was missing in ASP.NET MVC as it has not server side control like GridView.

Using the code


The good thing here is that we can still use the GridView of System.Web.UI.WebControls namespace in ASP.NET MVC and populate with data and get it rendered in the ASP.NET MVC view. Here is how the action method looks like

The Controller
 public ActionResult ListDataInGridView()
        {
            System.Web.UI.WebControls.GridView gView =
                new System.Web.UI.WebControls.GridView();
            gView.DataSource = db.PersonalDetails.ToList();
            gView.DataBind();

            using (System.IO.StringWriter sw = new System.IO.StringWriter())
            {
                using (System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw))
                {
                    gView.RenderControl(htw);
                    ViewBag.GridViewString = sw.ToString();
                }
            }
            return View();
        }

In this action method, we have first instantiated the GridView control and set its data source and called DataBind method that will bind the data from the data source. 

Next, we are using StringWriter and HtmlTextWriter to render the GridView content string into the StringWriter. The same is being set to the ViewBag.GridViewString.

The View

The View looks like below that simply use @Html.Raw method to write the content of the ViewBag.
@{ ViewBag.Title = "ListDataInGridView"; }

<h2>List Data In GridView</h2>

@Html.Raw(ViewBag.GridViewString)
Using @Html.Raw method is important as without this, it will simply render the HTML encoded characters of the GridView content string.


Conclusion


One of the most frequently used approach of listing the data was missing in ASP.NET MVC, thanks to GridView control that still works in ASP.NET MVC and can be used.

Hope this article was useful. Do subscribe for RSS feed and write your comments, suggestion. For more real time ASP.NET MVC tips and tricks, click here.
Recommendation
Read Attribute routing in ASP.NET MVC 5+ after this article.
Page copy protected against web site content infringement by Copyscape

About the Author

Sheonarayan
Full Name: Sheo Narayan
Member Level: HonoraryPlatinum
Member Status: Administrator
Member Since: 7/8/2008 6:32:14 PM
Country: India
Regards, Sheo Narayan http://www.dotnetfunda.com
http://www.snarayan.com
Ex-Microsoft MVP, Author, Writer, Mentor & architecting applications since year 2001. Connect me on http://www.facebook.com/sheo.narayan | https://twitter.com/sheonarayan | http://www.linkedin.com/in/sheonarayan

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)