public List <Pais_Mdl> PaisSeleccionado(int idPais) { List <Pais_Mdl> listapaises = new List <Pais_Mdl>(); MySqlConnection cnObj = new MySqlConnection(); cnObj = objConexion.Conectar(); if (cnObj != null) { MySqlCommand cmdObj = new MySqlCommand(); cmdObj.Connection = cnObj; string strSql; strSql = "SELECT "; strSql += "id_pais, "; strSql += "pais "; strSql += "FROM "; strSql += "pais "; strSql += "WHERE "; strSql += "id_pais = " + idPais + ""; cmdObj.CommandText = strSql; MySqlDataReader rdrObj = cmdObj.ExecuteReader(); while (rdrObj.Read()) { Pais_Mdl objPais = new Pais_Mdl { id_pais = rdrObj[0].ToString(), pais = rdrObj[1].ToString() }; listapaises.Add(objPais); } rdrObj.Close(); cnObj.Close(); } return(listapaises); }
public List <Pais_Mdl> ListaPais(string Servidor) { List <Pais_Mdl> listapais = new List <Pais_Mdl>(); SqlConnection cnObj = new SqlConnection(); cnObj = objConexion.Conectar_Master(Servidor); if (cnObj != null) { using (cnObj) { SqlCommand cmdObj = new SqlCommand(); cmdObj.Connection = cnObj; string strSql; strSql = "SELECT "; strSql += "id_pais, "; strSql += "pais "; strSql += "FROM "; strSql += "pais"; cmdObj.CommandText = strSql; SqlDataReader rdrObj = cmdObj.ExecuteReader(); while (rdrObj.Read()) { Pais_Mdl objPais = new Pais_Mdl(); objPais.id_pais = Convert.ToInt32(rdrObj[0].ToString()); objPais.pais = rdrObj[1].ToString(); listapais.Add(objPais); } rdrObj.Close(); } } return(listapais); }