C# (CSharp) IDBController.ExecuteNonQuery 예제들

예제 #1

파일: Connector.cs 프로젝트: JoshuaDoornik/ETLtool

        public void updateColumn(string selectAC, string updateTable, string updateColumn, string KeyColumn)
        {
            DataSet set = Source.Read(selectAC);

            foreach (DataRow item in set.Tables[set.Tables[0].ToString()].Rows)
            {
                Target.ExecuteNonQuery("UPDATE " + updateTable + " SET " + updateColumn + " = " + "'" + convertDate(item[updateColumn].ToString()) + "'"
                                       + " WHERE " + KeyColumn + " = " + item[KeyColumn].ToString());
            }
        }