private ComboBox createColumns()
{
ComboBox columns = new ComboBox();
MySqlDataReader dataReader = controller.executeReader("SHOW COLUMNS FROM " + table + ";");
while (dataReader.Read())
{
columns.Items.Add(dataReader.GetString("Field"));
}
dataReader.Close();
return(columns);
}
private List <string> getListOfColumn(string table, string database, string column)
{
MySqlDataReader columns = controller.executeReader("SELECT " + column + " FROM " + table + ";");
if (columns == null)
{
columns.Close();
return(new List <string>());
}
List <string> list = new List <string>();
while (columns.Read())
{
list.Add(columns.GetString(column));
}
columns.Close();
return(list);
}