public Form1() { InitializeComponent(); // Initialize form components dataBase = new MySQLConnection(); // Create database connection fillStates(); // Fill state drop box // Populate Categories Lists string qStr = "SELECT name FROM Categories"; List<string> qResults = new List<string>(); // Query must return list, even if we know there will only be one item qResults = dataBase.SQLSELECTExec(qStr, "name"); qResults.Sort(); // Sort query list qResults = qResults.Distinct().ToList(); foreach(string item in qResults) { listBoxCategoryDem.Items.Add(item); listBoxCategorySearch.Items.Add(item); } // Populate Attributes List qStr = "SELECT DISTINCT name FROM Attributes"; qResults = dataBase.SQLSELECTExec(qStr, "name"); qResults.Sort(); listBoxAttributes.Items.AddRange(qResults.ToArray()); }
public Form1() { InitializeComponent(); // Initialize form components fillStates(); // Fill state drop box dataBase = new MySQLConnection(); // Create database connection }
public Form1() { InitializeComponent(); // Initialize form components fillStates(); // Fill state drop box dataBase = new MySQLConnection(); // Create database connection // Populate Categories List string qStr = "SELECT name FROM Categories"; List <string> qResults = new List <string>(); // Query must return list, even if we know there will only be one item qResults = dataBase.SQLSELECTExec(qStr, "name"); qResults.Sort(); // Sort query list qResults = qResults.Distinct().ToList(); foreach (string item in qResults) { listBoxCategory.Items.Add(item); } }