protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            rpj = new RoadProject("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123");
            List<RoadProject> list = rpj.Load();

            RoadName.Text = list[0].RoadProjectName.ToString().Trim();
            Type.Text = list[0].RoadType.ToString();
            Grade.Text = list[0].RoadGrade.ToString();
            OwnerUnit.Text = list[0].OwnerUnit.ToString();
            DesignUnit.Text = list[0].DesignUnit.ToString();
            ProjectLocation.Text = list[0].ProjectLocation.ToString();
            RoadLength.Text = list[0].RoadLength.ToString();
            BeginStake.Text = list[0].BeginStake.ToString();
            EndStaeke.Text = list[0].EndStaeke.ToString();
            AmountOfExcavation.Text = list[0].AmountOfExcavation.ToString();
            AmountOfFill.Text = list[0].AmountOfFill.ToString();
            BridgeNumber.Text = list[0].BridgeNumber.ToString();
            CulvertNumber.Text = list[0].CulvertNumber.ToString();
            TunnelNumber.Text = list[0].TunnelNumber.ToString();
            PlaneIntersectionNumber.Text = list[0].PlaneIntersectionNumber.ToString();
            HighEmbankmentSlopeNumber.Text = list[0].HighEmbankmentSlopeNumber.ToString();
            HighExcavationSlopeNumber.Text = list[0].HighExcavationSlopeNumber.ToString();
            Description.Text = list[0].Description.ToString();

            if (string.IsNullOrEmpty(list[0].RoadProjectName.ToString().Trim()))
            {
                Response.Redirect("ProjectSet.aspx", true);
            }
            string b;
            b = rpj.AmountOfExcavation.ToString();

            HttpCookie objCookie = new HttpCookie("ProjectName", list[0].RoadProjectName.ToString().Trim());
            Response.Cookies.Add(objCookie);
        }
    }