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;
}
