public ProjectProp GetHomeProject() { ProjectProp p = new ProjectProp(); using (SqlConnection con = new SqlConnection(connect)) { con.Open(); SqlCommand selectOneProject = new SqlCommand("SELECT TOP 1 * FROM Project", con); SqlDataReader reader = selectOneProject.ExecuteReader(); reader.Read(); p.Project_Id = Convert.ToInt32(reader["Id"]); p.Project_Name = reader["Name"].ToString(); p.Project_Description = reader["Description"].ToString(); p.Project_Publisher = reader["Publisher"].ToString(); p.Project_Image = reader["Image"].ToString(); } return(p); }
public ProjectProp GetOneProject(int id) { ProjectProp p = new ProjectProp(); using (SqlConnection con = new SqlConnection(connect)) { con.Open(); SqlCommand selectProduct = new SqlCommand("SELECT * FROM Project WHERE Id = @id", con); selectProduct.Parameters.AddWithValue("@id", id); SqlDataReader reader = selectProduct.ExecuteReader(); p.Project_Id = Convert.ToInt32(reader["Id"]); p.Project_Name = reader["Name"].ToString(); p.Project_Description = reader["Description"].ToString(); p.Project_Publisher = reader["Publisher"].ToString(); p.Project_Image = reader["Image"].ToString(); } return(p); }
public List <ProjectProp> GetProject() { List <ProjectProp> projects = new List <ProjectProp>(); using (SqlConnection con = new SqlConnection(connect)) { con.Open(); SqlCommand selectProject = new SqlCommand("SELECT * FROM Project", con); SqlDataReader reader = selectProject.ExecuteReader(); while (reader.Read()) { ProjectProp p = new ProjectProp(); p.Project_Id = Convert.ToInt32(reader["Id"]); p.Project_Name = reader["Name"].ToString(); p.Project_Description = reader["Description"].ToString(); p.Project_Publisher = reader["Publisher"].ToString(); p.Project_Image = reader["Image"].ToString(); projects.Add(p); } } return(projects); }
protected void Page_Load(object sender, EventArgs e) { project = db.GetHomeProject(); }