How to fetch sharepoint list data into a grid - Server Object Model

Here in this example in my sharepoint site i have created  a  list called "Employee Details"

with two columns "Name" and "EmpID".

Now in my sharepoint visual webpart project ,i have placed a datagrid and renamed it to  "grdDisplay".

Then i used the following in the code behind page to fetch data from the list into the datagrid.

using System;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using Microsoft.SharePoint;

using Microsoft.SharePoint.WebControls;

using System.Data;

using System.IO;

namespace fetchlistdata

{

    public partial class fetchlistdataUserControl : UserControl

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            gridData();

        }

        protected void gridData()

        {

            SPSite site = SPContext.Current.Site;

            SPWeb web = SPContext.Current.Web;

            SPList list = web.Lists["Employee Details"];

            SPQuery query = new SPQuery();

           

            SPListItemCollection items = list.GetItems(query);

            DataTable tbl = new DataTable();

            tbl.Columns.Add("Name");

            tbl.Columns.Add("EmpID");

            DataRow tr;

            foreach (SPListItem item in items)

            {

                tr = tbl.Rows.Add();

                tr["Name"] = Convert.ToString(item["Name]);

                tr["EmpID"] = Convert.ToString(item["EmpID"]);

            }

            grdDisplay.DataSource = tbl;

            grdDisplay.DataBind();

                   

        }

}

}