/**
* @brief DelData
* @param[in] string nameString 登録名
* @return void
* @note Table から 引数で受けた名前のデータ削除
*/
void DelData(string nameStr)
{
var db = new DataClasses1DataContext(ConnectionString);
var que = from tb in db.Table1
where tb.Name.Contains(nameStr)
select tb;
foreach (var slct in que)
{
db.Table1.DeleteOnSubmit(slct);
}
db.SubmitChanges();
}
/**
* @brief AddOneData
* @param[in] string nameString 登録名
* @return void
* @note Table に 引数で受けた名前のデータ登録
*/
void AddOneData(string nameStr)
{
var db = new DataClasses1DataContext(ConnectionString);
Table1 tb = new Table1();
tb.Name = nameStr; // 作者
db.Table1.InsertOnSubmit(tb);
db.SubmitChanges();
}
/**
* @brief button3_Click
* @param[in] object e
* @param[in] EventArgs e
* @return void
* @note "Asan"/"Bsan" textBox1 に表示
*/
private void button3_Click(object sender, EventArgs e)
{
var db = new DataClasses1DataContext(ConnectionString);
var q =
from s in db.Table1
where s.Name.Contains("Asan") || s.Name.Contains("Bsan")
select new { Title = s.Name };
textBox1.Clear();
foreach (var s in q)
{
Console.Write("{0}\n", s.Title);
textBox1.AppendText(s.Title + "\n");
}
}