private void button3_Click(object sender, EventArgs e) { XDocument xml; try { Utility.HtmlUtil htmlUtil = new Utility.HtmlUtil(); xml = htmlUtil.ParseHtml(this.textBox1.Text); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } var ns = xml.Root.Name.Namespace; var q = from s in xml.Descendants(ns + "tr") select s; foreach (var s in q) { //Console.WriteLine(s.Value ); foreach (var s2 in s.Descendants()) { Console.WriteLine(s2.Value); } } Utility.FinanceUtil finance = new Utility.FinanceUtil(); dividendEntityBindingSource.DataSource = finance.GetDividendEntityList(); }
private void btnDividend_Click(object sender, EventArgs e) { using (Utility.DbUtil db = new Utility.DbUtil()) { // テーブルを作成 List <decimal> tblLst = db.DBSelect <decimal>("SELECT COUNT(*) CNT FROM sqlite_master WHERE type = 'table' AND name = 'dividend'"); if (tblLst[0] > 0) { db.DBExecuteSQL("DROP TABLE dividend "); } string sql = @"CREATE TABLE dividend ( OrderNo NUMERIC ,StockCode NUMERIC ,Market TEXT ,CompanyName TEXT ,Dividend NUMERIC ,DividendYield NUMERIC ,DetailUrl TEXT ) "; db.DBExecuteSQL(sql); List <Utility.DividendEntity> list = new List <Utility.DividendEntity>(); Utility.FinanceUtil finance = new Utility.FinanceUtil(); list = finance.GetDividendEntityList(); string insertSql = @"INSERT INTO dividend ( OrderNo ,StockCode ,Market ,CompanyName ,Dividend ,DividendYield ,DetailUrl ) VALUES ( :OrderNo ,:StockCode ,:Market ,:CompanyName ,:Dividend ,:DividendYield ,:DetailUrl )"; db.DBInsert(insertSql, list); } // 配当データをSqliteから取得 this.dgvDividend.DataSource = GetDividendList(); }