protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { divAddTask.Visible = false; divComment.Visible = false; divAddComment.Visible = false; } SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["LoginConnectionString"].ConnectionString); con.Open(); String test = "select Name from ProjectInformation where Name='" + Session["project"] + "'"; SqlCommand com = new SqlCommand(test, con); String temp = com.ExecuteScalar().ToString().Trim(); LProjectName.Text = temp; test = "select CodeName from ProjectInformation where Name='" + Session["project"] + "'"; com = new SqlCommand(test, con); temp = com.ExecuteScalar().ToString().Trim(); LCodeName.Text = temp; test = "select Description from ProjectInformation where Name='" + Session["project"] + "'"; com = new SqlCommand(test, con); temp = com.ExecuteScalar().ToString().Trim(); LProjectDescription.Text = temp; test = "select StartDate from ProjectInformation where Name='" + Session["project"] + "'"; com = new SqlCommand(test, con); temp = com.ExecuteScalar().ToString().Trim(); LStartDate.Text = temp; test = "select EndDate from ProjectInformation where Name='" + Session["project"] + "'"; com = new SqlCommand(test, con); temp = com.ExecuteScalar().ToString().Trim(); LEndDate.Text = temp; test = "select Duration from ProjectInformation where Name='" + Session["project"] + "'"; com = new SqlCommand(test, con); temp = com.ExecuteScalar().ToString().Trim(); LDuration.Text = temp; test = "select Status from ProjectInformation where Name='" + Session["project"] + "'"; com = new SqlCommand(test, con); temp = com.ExecuteScalar().ToString().Trim(); LProjectStatus.Text = temp; con.Close(); string cs = ConfigurationManager.ConnectionStrings["LoginConnectionString"].ConnectionString; using (SqlConnection conn = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("Select ResourcePerson as Name, Designation from ProjectResourcePerson where ProjectName='" + Session["project"] + "'", conn); //SqlCommand cmd = new SqlCommand("Select * from TimeTable", con); conn.Open(); ProjectResourcePerson.DataSource = cmd.ExecuteReader(); ProjectResourcePerson.DataBind(); conn.Close(); } using (SqlConnection conn = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("Select Description, AssignedTo, AssignedBy, Priority, DueDate from ProjectTask where ProjectName='" + Session["project"] + "'", conn); //SqlCommand cmd = new SqlCommand("Select * from TimeTable", con); conn.Open(); ProjectTask.DataSource = cmd.ExecuteReader(); ProjectTask.DataBind(); conn.Close(); } }