public void syncemp() { projectID = Request.QueryString["pid"]; using (conn = new SqlConnection(HomePage.connectString)) { try { conn.Open(); SqlCommand command = new SqlCommand("DisplayTeam", conn); command.Parameters.AddWithValue("Project_ID", projectID); command.CommandType = CommandType.StoredProcedure; SqlDataAdapter dataAdp = new SqlDataAdapter(command); DataSet ds = new DataSet(); dataAdp.Fill(ds); GridViewTeamMember.DataSource = ds; GridViewTeamMember.DataBind(); conn.Close(); } catch (Exception ex) { } } }
public void syncemp() { //try //{ // Pid = Session["Project_ID"].ToString(); // Label1.Text = Pid; //} //catch (Exception ex) //{ //} using (conn = new SqlConnection(connstring)) { try { conn.Open(); SqlCommand command = new SqlCommand("DisplayTeam", conn); command.Parameters.AddWithValue("Project_ID", Pid); command.CommandType = CommandType.StoredProcedure; SqlDataAdapter dataAdp = new SqlDataAdapter(command); DataSet ds = new DataSet(); dataAdp.Fill(ds); GridViewTeamMember.DataSource = ds; GridViewTeamMember.DataBind(); conn.Close(); } catch (Exception ex) { } } }