Line 138: string connAreaString = ConfigurationManager.AppSettings["THConnectionString"];
Line 139: MySqlConnection cnxArea = new MySqlConnection(connAreaString);
Line 140: cnxArea.Open();
Line 141: MySqlDataAdapter adapterArea = new MySqlDataAdapter();
Line 142: string cmdAreaText = "SELECT Location, URLLocation, ('" + _country + "') As Country, ('" + PLPagetype + "') As PageType, (CASE WHEN '" + Cpage + "' = '1' THEN CONCAT('/', '" + _country + "/rent/','" + PLPagetype + "-in-',URLLocation,'.html') WHEN '" + Cpage + "' = '2' THEN CONCAT('/', '" + _country + "/','villa-in-',URLLocation,'.html') END) AS URLString, COUNT(*) AS LocationCount, CONCAT(Location, ' (', COUNT(*), ')') AS Details FROM tblproperty_" + _country + " WHERE (Area LIKE ?Area) GROUP BY Location ORDER BY Location";
|