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