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.