public List <Chamado> ListarAbertosUser(String user) { string connectionString = ConfigurationManager.ConnectionStrings["bancodedados"].ConnectionString; List <Chamado> lst = new List <Chamado>(); using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand comando = new SqlCommand()) { comando.Connection = conn; comando.CommandText = "select * from tb_chamados WHERE id_usuario = '" + user + "'"; conn.Open(); using (SqlDataReader reader = comando.ExecuteReader()) { lst = new List <Chamado>(); while (reader.Read()) { lst.Add(Chamado.Popular(reader)); } } } } return(lst); }