protected void Button8_Click(object sender, EventArgs e) { DateTime tdt; if (dp3.Text != "") { if (dp4.Text != "") { tdt = DateTime.Parse(dp4.Text); } else { tdt = System.DateTime.Now; } DateTime fdt = DateTime.Parse(dp3.Text); try { using (AdvInvSystemEntities dbobj = new AdvInvSystemEntities()) { var fundTrns = dbobj.sp_Add_fund(fdt, tdt).ToList(); GridView4.DataSource = fundTrns; GridView4.DataBind(); } } catch (Exception) { } } }