public static DBCities GetDataByName(string idx) { DBCities data = null; MySqlConnection con = DBConnection.ConnectLocalAddressDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE city='" + idx + "'", con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); data = new DBCities(); data.ID = reader.GetInt32(0); data.NAME = reader.GetString(1); data.PROVID = reader.GetInt32(2); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return(data); }
public static List <DBCities> GetDataByProvice(int idx) { List <DBCities> data = new List <DBCities>(); MySqlConnection con = DBConnection.ConnectLocalAddressDatabase(); try { MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + tablename + " WHERE province_id=" + idx, con); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { DBCities rawData = new DBCities(); rawData.ID = reader.GetInt32(0); rawData.NAME = reader.GetString(1); rawData.PROVID = reader.GetInt32(2); data.Add(rawData); } } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } return(data); }