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); } }