protected void Page_Load(object sender, EventArgs e)
{
//Use the dataset returned from the code to be the
//data source of the grid view
System.Data.DataSet ds = EventsList.getTheatre();
dgvTheatre.DataSource = ds.Tables["dtTheatre"];
dgvTheatre.AllowPaging = true;
dgvTheatre.PageSize = 10;
dgvTheatre.DataBind();
}//end of page load