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