public MainWindow() { InitializeComponent(); combo_stock_index.SelectedIndex = 0; DbSql.DBConnect(); company_infos = DbSql.LoadCompanyList(); foreach (object obj in company_infos) { PageEquityList.EquityInfo ci = (PageEquityList.EquityInfo)obj; combo_stock_index.Items.Add(ci.index); } }
public static void AddEquityInfo(PageEquityList.EquityInfo info) { string sql_ins = "INSERT INTO StockInfo ( `name`, `index`, `ipo_date`) VALUES (\"" + info.name + "\",\"" + info.index + "\",\"" + info.ipo_date + "\")"; MySqlCommand cmd_insert = new MySqlCommand(sql_ins, conn); try { cmd_insert.ExecuteNonQuery(); } catch (MySql.Data.MySqlClient.MySqlException ex) { //MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, // "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }