Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display Excel file data using WebGrid in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library into a DataSet and then the DataSet will be used to populate WebGrid in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) WebGrid using ADO.Net in ASP.Net MVC Razor.

Inside the Controller, the records from the Database Table will be fetched using traditional ADO.Net method i.e. using SqlConnection, SqlCommand, SqlDataAdapter, etc.

The fetched records will be populated into a DataSet which will be ultimately used to populate the WebGrid in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to bind (populate) WebGrid using dynamic DataTable (DataSet) in ASP.Net MVC Razor.

Inside the Controller, first a DataTable object is created with some dynamic Columns and then records are added to the DataTable.

Finally the DataTable is added to a DataSet which is later used to populate the WebGrid in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to populate Bar and Column Charts from database using ASP.Net Chart control in C# and VB.Net.