public static ENResultOperation Listar_Nombre(string cNombre) { SqlCommand CMD = new SqlCommand("SELECT * FROM TRANSPORTISTA WHERE TRAN_RAZON_SOCIAL LIKE '" + cNombre + "%'"); return(TransportistaDA.Procesar_SQL(CMD)); }
public static ENResultOperation Listar(string Texto_Buscar) { SqlCommand CMD = new SqlCommand("SELECT * FROM TRANSPORTISTA WHERE TRAN_RAZON_SOCIAL LIKE '" + Texto_Buscar + "%'"); return(TransportistaDA.Procesar_SQL(CMD)); /* * SqlCommand CMD = new SqlCommand("PA_TRANSPORTISTA_LISTAR"); * CMD.Parameters.Add(Parametros_SQL.nombre_error, SqlDbType.VarChar).Value = Texto_Buscar; * * CMD.Parameters.Add("@RETURN", SqlDbType.Int); * CMD.Parameters["@RETURN"].Value = DBNull.Value; * CMD.Parameters["@RETURN"].Direction = ParameterDirection.ReturnValue; * return TransportistaDA.Acceder(CMD); */ }