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