/// <summary> /// Veri tabanından istenilen sütunun verilerini çeker. /// </summary> public void GetParams(string _table, Selected.Mode mode) { try { GetAll(_table, mode); } catch (Exception ex) { MessageBox.Show("Lütfen Gerekli Alanları Doldurun ve İnternete Bağlı Olduğunuzdan emin olun! " + ex.ToString(), "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// İstenilen tablodan ID ve Name'i çeker. /// </summary> public void GetAll(string _table, Selected.Mode mode) { string cmd = "SELECT ID, NAME FROM " + _table; Connect(); using (MySqlDataReader reader = new MySqlCommand(cmd, connection).ExecuteReader()) { switch (mode) { case Selected.Mode.Name: Selected.NameInt.Clear(); Selected.NameName.Clear(); while (reader.Read()) { Selected.NameInt.Add(reader.GetInt32(0)); Selected.NameName.Add(reader.GetString(1)); } break; case Selected.Mode.Type: Selected.TypeInt.Clear(); Selected.TypeName.Clear(); while (reader.Read()) { Selected.TypeInt.Add(reader.GetInt32(0)); Selected.TypeName.Add(reader.GetString(1)); } break; case Selected.Mode.Owner: Selected.OwnerInt.Clear(); Selected.OwnerName.Clear(); while (reader.Read()) { Selected.OwnerInt.Add(reader.GetInt32(0)); Selected.OwnerName.Add(reader.GetString(1)); } break; } } Disconnect(); }