How to retrieve data from database in mvc 3

See more:

C#

I dropped in a table in Index.cshtml. ( MVC 3 razor view).

Now I want to add the following code to retrieve the data from the database and fill the table.

Where do I put this code?.

Do I put it in index.cshtml or homeController.cs or where else?

string s=ConfigurationManager.ConnectionStrings["constr"].ConnectionString;   
string sel = "select * from TableName";   
SqlConnection con = new SqlConnection(s);   
SqlCommand cmd = new SqlCommand(sel, con);   
SqlDataAdapter sda = new SqlDataAdapter(cmd);   
DataSet ds = new DataSet();   
sda.Fill(ds);   
GridView1.DataSource = ds;   
GridView1.DataBind();