/// <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();
}
