protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserName"] == null) { Response.Redirect("FrmLogin.aspx"); } DD.BindActivity(DdlActivity); //TxtFDate.Text = Session["EntryDate"].ToString(); //TxtTDate.Text = Session["EntryDate"].ToString(); TxtBrID.Text = Session["BRCD"].ToString(); //added by ankita 07/10/2017 to make user frndly TxtFDate.Text = Conn.sExecuteScalar("select '01/04/'+ convert(varchar(10),(year(dateadd(month, -3,'" + Conn.ConvertDate(Session["EntryDate"].ToString()) + "'))))"); TxtTDate.Text = Session["EntryDate"].ToString(); } }