20221225

//コネクションを生成する
using (OracleConnection conn = new OracleConnection(connStr))
{
//データベースの接続開始
conn.Open();
Console.WriteLine("接続完了");

//コマンドを生成する
using (OracleCommand cmd = new OracleCommand(strSql))
{
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;

//SQL実行
DataTable dt = new DataTable();//データテーブル
using (var da = new OracleDataAdapter(cmd))
{
//connection.Open();
da.Fill(dt);
}
//cmd.ExecuteNonQuery();
//Console.WriteLine("SQL実行完了");
dataGridView2.DataSource = dt;

//各列の項目をupdateする
foreach (DataColumn dc in dt.Columns)
{
foreach (DataRow dr in dt.Rows)
{
//Console.WriteLine(dr[dc.ColumnName]);

strSql =//★★ここから★★
"update DEPT_BK DBK " +
"set " + (dr[dc.ColumnName]) + " = " +
"(" +
"select D.LOC " +
"from DEPT D " +
"where DBK.DEPTNO = D.DEPTNO " +
"and D.KOUSHINBI > DBK.KOUSHINBI" +
") " +
"where exists (select * from DEPT D where DBK.DEPTNO = D.DEPTNO and D.KOUSHINBI > DBK.KOUSHINBI)";

}
//Console.WriteLine(dc.ColumnName);

}

}