private bool SqlLoadVenders() { // Populate the Starbase Combox string m_QueryStr = "SELECT `starbase_vender_groups`.`GroupID`,`starbase_vender_groups`.`GroupName` FROM `starbase_vender_groups`"; MySqlDataReader m_Reader = ExcuteSQLQuery(m_QueryStr); // Make sure the box is cleared Vender_SelectGroup.Items.Clear(); VGroups.Clear(); // Reset all data // Has no data yet if (!m_Reader.HasRows) { return(true); } int index = 0; VenderGroup VenderGroupData; while (m_Reader.Read()) { VenderGroupData = new VenderGroup(); // Save data into a structure VenderGroupData.GroupID = m_Reader.GetInt32(0); // Save Group ID VenderGroupData.GroupName = m_Reader.GetString(1); // Save Group Name // Put into List Vender_SelectGroup.Items.Add(m_Reader.GetString(1)); VGroups.Add(VenderGroupData); // Add to List // Update Index index++; } return(true); }
private bool SqlLoadVenders() { // Populate the Starbase Combox string m_QueryStr = "SELECT `starbase_vender_groups`.`GroupID`,`starbase_vender_groups`.`GroupName` FROM `starbase_vender_groups`"; MySqlDataReader m_Reader = ExcuteSQLQuery(m_QueryStr); // Make sure the box is cleared Vender_SelectGroup.Items.Clear(); VGroups.Clear(); // Reset all data // Has no data yet if (!m_Reader.HasRows) return true; int index = 0; VenderGroup VenderGroupData; while (m_Reader.Read()) { VenderGroupData = new VenderGroup(); // Save data into a structure VenderGroupData.GroupID = m_Reader.GetInt32(0); // Save Group ID VenderGroupData.GroupName = m_Reader.GetString(1); // Save Group Name // Put into List Vender_SelectGroup.Items.Add(m_Reader.GetString(1)); VGroups.Add(VenderGroupData); // Add to List // Update Index index++; } return true; }