Datetime problem solve

Date time Format solution

//in page load
txtAnsweredOn.Attributes.Add("data-date-format", System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern.ToString().Replace("M", "m").Replace("yyyy", "yy"));

//in Bind Detail
txtAnsweredOn.Text = ((DateTime)dataReader["AnsweredOn"]).ToString("MM/dd/yyyy");


//in Submit Button
sqlCommand.Parameters.Add(new SqlParameter("@AnsweredOn", Convert.ToDateTime(txtAnsweredOn.Text).ToString("MM/dd/yyyy")));

Enum Entity Declaration

 public partial class Facility
    {
        public FacilityTypes FacilityType
        {
            get { return (FacilityTypes)this.FacilityTypeId; }
            set { this.FacilityTypeId = (int)value; }
        }
    }

    public enum FacilityTypes
    {
        Hostel = 1,
        Room,
        Area
    }

 FacilityTypes myVar = FacilityTypes.Hostel;

            int med = (int)FacilityTypes.Hostel;

GridView remove all cells but one(footer)

if (e.Row.RowType == DataControlRowType.Footer)
            {
                //remove all cells but one, so GridView1.Columns.Count-1
                for (int i = 0; i < grvLeaveDetail.Columns.Count - 1; i++)
                    e.Row.Cells.RemoveAt(0);

                e.Row.Cells[0].ColumnSpan = grvLeaveDetail.Columns.Count;
                e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Left;

                if (ViewStateLeaveDetail.Count == 0)
                    e.Row.Cells[0].Text = "You have to apply at least one leave";
                else
                    e.Row.Cells[0].Text = "You have applied " + DaysCount + " leave";
            }